Update query (2003)

[LindaR]

I have a list of unique ids that I want to update some fields for those unique ids in a table. The fields are - "HMIG ind" - I want to change what is in that field to an "N".
"HMIG Members" - I want to change what is there to a 0 and the fields "HMIG Contracts" - I want to change what is there to a 0. How would I set up the update query since it is only for certain unique ids in that table?

[HansV]

How many unique IDs are there in the list? If the number is small, you can set the condition for the ID field to something like this:

In (13, 21, 34, 55, 89, 144, 233)

or if the IDs are text values:

In ("ab", "cde", "fghi", "jklmno", "pqrs", "tuv", "wx")

[LindaR]

I did only have 6 unique ids to update so that worked fine. What if I had a list of a 1000 or more unique ids to update. Would I bring in a table of those ids and connect it to the table (one to one) I want to update?

[HansV]

Yes, you'd have to create a table containing the unique IDs, add that table to the query and join it to the other table on the ID field.