Update 6 values in one qry

R

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
 
M

[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
M

[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.
 
Top