Can 2 Union Queries Be used in Another UNION ??

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date 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
 
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
..
 
Back
Top