Update query with multiple part if statements

[Darkmatter5]

I have a table where I have 5 columns, (BatteryL1, BatteryL2, BatteryR1, BatteryR2 and BatterySize).

I want to update BatterySize, with a value if any one of the above listed columns contains a specific value using something like 'LIKE' in the query.

For example:
UPDATE Customers
SET BatterySize=13
WHERE BatteryL1 LIKE '%13%'
OR BatteryL2 LIKE '%13%'
OR BatteryR1 LIKE '%13%'
OR BatteryR2 LIKE '%13%'
OR BatterySize LIKE '%13%'

[June7]

Appears to be non-normalized data structure.

Saving calculated data is usually a bad idea. The calculation can be done when needed.

What does data in those fields actually look like? Will those fields have other values than 13?

The usual wildcard for Access is * character. Is this a split db and the backend is SQL? http://office.microsoft.com/en-us/ac...005188185.aspx

[orange]

I agree in general with June7's comments. However, % is the wildcard if using an ADO recordset.

[Darkmatter5]

Yep, I just changed it to * and it's working. Thanks for the input.