That should work. This below I have written may be less lines. What happens when you try? Is the field a text or numeric? If it is text then you will have to put your criteria in quotes.
UPDATE Table1 SET IIF(Field2 = 800,8), IIF(Field3 = 800,8), IIF(Field4 = 800,8) May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: John Scannell <[EMAIL PROTECTED]> To: [email protected] Sent: Sunday, December 31, 2006 2:17:34 PM Subject: [ms_access] update multiple fields Not sure where my mistake is. I am trying to update multiple fields. Possibly there is a beter way. My database which was imported from a focus datbase has 900, 800 etc. This is supposed to represent 9 hrs and 8 hours. I am trying to convert the 800 to 8 and the 900 to 9 as an example. I want to do it with as few update queries as possible. Right now I am doing one number per field at a time. I want all fields to be updated at once. Any help appreciated. Sample SQL below, which does not work. UPDATE Table1 SET Table1.Field2 = 8 WHERE (((Table1.Field2) =800)) UPDATE Table1 SET Table1.Field3 = 8 WHERE (((Table1.Field3) =800)) UPDATE Table1 SET Table1.Field4 = 8 WHERE (((Table1.Field4) =800)) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
