Need help on update query, please

[bravura]

I set it up like this but it's updating every line in my table, not just those lines that meet field criteria.

Update tbl_A Set tbl_A.USFLAG = -1 (true)
Where ((tbl_A.Field1 = "X" or "Y" or "Z") OR (tbl_A.Field2 = "X" or "Y" or "Z") etc. etc. etc. )) ;

///

Want to update USFLAG field to TRUE (-1) if Field1 = Alpha, Bravo or Charlie, or if Field2 = Alpha, Bravo or Charlie, etc.

 

[welshgasman]

You need to repeat your test using the field name each time.

tbl_A.Field1 = "X" or tbl_A.Field1 = "Y"

Perhaps consider using IN() instead?

You can always test your logic in the Immediate Window? Try setting a variable, then print the result of your comparison, and see what you get.