Update Query Using the IN operator

[ALewis06]

I'm not proficient at all with SQL but I think the IN operator would work here: I have a table with Name, Acct Number, Site ID. On several of the records, the data got mixed up and I've discovered there's a list of 13 Site IDs that all need to be changed to the same Acct Number. How can I do that in an update query in Access 2010?

 

[pbaldy]

Along the lines of

UPDATE TableName
SET FieldName = Whatever
WHERE SiteID In(1,2,3)