Update 6 values in one qry

  • Thread starter Thread starter Razor
  • Start date Start date
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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
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.
 
Back
Top