Share this page:

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:

Microsoft Access