Update 6 values in one qry

[Razor]

Hi,

I want to write an update query that maps 6 individual
values in a field to 6 other values RESPECTIVELY.

I know how to do this by writing 6 different queries, but
how can I update all 6 values in one query execution?

Is it advisable to do this using a translation table
instead?

Can you show me both techniques?

Thanks,

Razor

 

[[MVP] S.Clark]

If each Update requires different criteria, then stick with the 6 queries.
Automate with a Macro or Module.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Razor]

Thanks Steve. Is it possible to do this using a table?

 

[[MVP] S.Clark]

The Macro or Module could look at the table to perform the automation, but
don't really see how it applies here. You'll need to describe more what the
table's role would be.