Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!

Use a conditional expression :

IIF(Criteria 1 is true), Criteria 1 response, Criteria 2 response

Jen