two statements in one?

  • Thread starter Thread starter js
  • Start date Start date
Hi, can I group two update statements into one query?
Click to expand...

Only one UPDATE clause, but that clause can update many fields: e.g.

UPDATE mytable
SET thisfield = <something>,
thatfield = <something else>,
anotherfield = <whatever>
WHERE <criteria>

John W. Vinson[MVP]
 
Hi js
You can join together only quries that return records, ""Select queries
you can't join update query together, you wont see them in the list of
quries and tables to select from
 
You must log in or register to reply here.

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

IIF statement to compare two fields. 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
How do I execute multiple SQL statements in Access?? 3
IIF Statement in a Criteria In() statment...? 2
If statement in Update query 7
Iif Statement 2
Repetitive Results 3
Union Query with two crosstabs 2

Back
Top