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))
