combining queries

[gr8whitewaldron]

I have a form that uses a number of update queries to determine a value. How would I put all the update statements into one query?

 

[Norris68]

You can only update one table at a time, but you can update multiple fields within the same record.
e.g. UPDATE MyTable SET Field1 = 1, Field2 = 2 WHERE Field1 = 0

See the help (Access & SQL BOL) for further information.

 

[cmmrfrds]

You can send multiple sql statements in a batch by delimiting with semi colon.

Dim mysql as string
dim cn as new adodb.connection

mysql = "select * from tab1; select * from tab2"

cn.execute mysql