Update 6 values in one qry (repost)

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?

Steve Clark already said it can't be done in one qry but I
need to know at least how to do the update via a parameter
table - I'm envisioning a 2-field 6-record table.

Thanks,

Razor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update 6 values in one qry 3
Query between 2 tables with one-to-many relationship 2
update two fields at once 1
Run 3 update queries at once 9
Update qry removing ONLY Alpha 4
Parameter in Qry 2
Qry not pulling bound column problem 6
can't execute update query 1

Top