Are Compound Queries and Subqueries allowed in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are Compound Queries and Subqueries allowed in Access? If not then how do you
get around it?
 
Are Compound Queries and Subqueries allowed in Access? If not then how do you
get around it?
Click to expand...

Subqueries yes; compound queries (if you mean several queries
separated by semicolons), no. You can run multiple Action queries from
a macro or (better) using the Execute method of a Querydef object from
VBA code.

John W. Vinson[MVP]
 
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

Another Compound and Subquery question 1
Query is too complex 5
How can I LEFT JOIN two subqueries in the same SELECT statement? 7
Multi-level Group By Clause is not allowed in a subquery 4
Referring to fields in a subquery 1
What put the bang! in my subquery 2
Subquery help 7
NOT IN and Sub Query 2

Back
Top