Is it possible to construct an update query that updates multiple records at the same time based on different information? For example, let's say I have a list of 1000 records and one of the fields has the numbers 1,2,3,4 or 5. I want to change those values to something else ALL at the same time. I want all the records with a 1 to become one value, 2 with another value and so on. Right now I have several queries that I run in a row in order to accomplish this. Thanks!