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

Three seperate update statements/criteria?

Yes, three seperate criteria statements? Any ideas Rich?

You can have only one set of criteria for a query. Therefore if the criteria is different for each field, you will need separate queries.