Can 2 Union Queries Be used in Another UNION ??

  • Thread starter kev100 via AccessMonster.com
  • Start date
K

kev100 via AccessMonster.com

I have created 2 separate Union Queries that work just fine.

Can these 2 union queries be used in Another Union query (that will
essentially combine the output of those 2)?

Thanks very much,
Kev
 
J

John Spencer

Yes, as long as the two union queries are outputting data in the same
structure and as long as the query engine doesn't decide that the
combination of the union queries is too complex.

Have you tried to do this? If so, did it fail? And if it failed were there
any error messages?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Top