Update query needs to update several blank fields

[autiger58]

Hi:
Is it possible to have an update query that updates multiple fields using SQL? Here's an example: In a 30 field DB, I would like to run an update query that updates field 1 with 'A', field 4 with 'M', field 12 with '8' and field 21 with 'Z' I can do separate updates on each field using SQL but I haven't been able to string multiple updates to different fields into the same SQL update query. Does anyone have an idea?

Thanks,

Michael

FYI: I do use field numbers and not field names in my database as indicated above.

[Micron]

Are the fields in the same table? Post what you've tried to give a better idea of what you're dealing with.