Fields are being set to null, but not how I'm intending

[Darkmatter5]

Here's the query I'm running.

UPDATE Customers SET BatterySize = NULL
WHERE BatterySize <> '10'
OR BatterySize <> '13'
OR BatterySize <> '312'
OR BatterySize <> '675';




My intent is if a record has anything in it's field "BatterySize", other than 10, 13, 312 or 675, I need to set it to NULL. The end result data is essentially numerical, but due to the data I need to import, this field may or may not have text, that's why I have to set with single quotes and not just the value.

Thanks for your help!

[ItsMe]

Have you tried creating a select query and using the AND operator vs the OR operator?

If there are not many records and this process is not going to be repeated, I suppose you could run four action queries.

[June7]

BatterySize is a text type field?

Maybe:

UPDATE Customers SET BatterySize=Null WHERE BatterySize NOT IN ('10', '13', '312', '675')

[ItsMe]

I always forget the NOT IN