MS Access: Update Query that updates one field based on the value of another field in Access 2003/XP/2000/97
Question: In Microsoft Access 2003/XP/2000/97, I have a table called DQListUpdate and I would like to update the [Area Number] field with the value "Mesa001" when the [St Zip] field is equal to 85201 or 85203.
How can I do this?
Answer: First, you need to create an Update Query. To do this, start a new query in Design View.
Then under the "Query" menu, select "Update Query".
Then build your query like the one below: