Update Query - more than one field?

[Rosebud22]

Hello,

Does anyone have any ideas on how to update multiple field in one update query but update them independently? Independently meaning if two out of three fields meet the criteria, just update those two fields and leave the third alone?

Thanks,
Rosebud

 

[Rich]

Three seperate update statements/criteria?

 

[Rosebud22]

Yes, three seperate criteria statements? Any ideas Rich?