Update multiple unrelated fields

[sarsmelt]

Is there any way for me to update fields in the same table that are completely unrelated in one query?

This is the code I have so far
UPDATE Product_Code_Data SET Product_Code_Data.Machine1 = "DGM2", Product_Code_Data.Machine2 = "DGM2", Product_Code_Data.Machine3 = "DGM2", Product_Code_Data.Machine4 = "DGM2"


WHERE (((Product_Code_Data.Machine1)="test") OR ((Product_Code_Data.Machine2)="test") OR ((Product_Code_Data.Machine3)="test") OR ((Product_Code_Data.Machine4)="test"));
but it updates every Machine if one field contains "test"

What I want it to do is search each field individually and then make the decision if something needs to be updated.

Is this possible or do I have to make separate update queries?

Thanks!
Sarah

[ranman256]

Whatever logic works. If you can put it in 1 query fine.
If it takes many queries, thats fine too.
Stick them all in a macro and run as many queries as you need.
It dont cost nuthin.

[sarsmelt]

If I put them in a macro though how can I change the criteria/update to?

[sarsmelt]

Nevermind I'm going to use parameters.

Thanks for the help!