Update Query selecting multiple values in one field

[Zipster1967]

I have a table that contains a location field which is numeric that represents the county of the record. I want to update the Zone field so that different counties i,e, numbers are given different zone numbers. Say I want to update the Zone field to 1 in all the records where the infocode (which is the county code numeric) is equal to any of the following values 6,17,46,47, 55 What is the easiest way to build this query?

[NTC]

well the way you implement it in the end will depend on whether this is a 1 time thing by you the administrator - or a feature that the nontechnical user will do regularly; but having said that the concept is the same:

1st make a query that collects the right records to be changed. In your example it is a query with OR between your values (or put them on separate rows in query design). Sanity check that this is working ok and name/save it as: ToChange query

Then make a select query using ToChange as your source in query design - and then make it into an Update Query. At this point add the field that you want to update - and enter in the value you want to use.

An Access textbook will have examples of Update Queries - you should be sure to have one.

Hope this helps.