Are Compound Queries and Subqueries allowed in Access? If not then how do you get around it?
J jacob Apr 27, 2005 #1 Are Compound Queries and Subqueries allowed in Access? If not then how do you get around it?
J John Vinson Apr 28, 2005 #2 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]
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]
