Viewing Results from Multiple Queries

N

Nick.Korynski

I have created multiple queries and was wondering if there is any way
to view all of their data at once. Can a temporary table be created
through vb to dump the data in the queries? Some of the fields in the
queries are not common to the other queries, but if there is a way to
only view the common information, that would serve my purpose as well.
Thanks.

Nick
 
J

John Nurick

Hi Nick,

Sounds as if you need a Union query.

I have created multiple queries and was wondering if there is any way
to view all of their data at once. Can a temporary table be created
through vb to dump the data in the queries? Some of the fields in the
queries are not common to the other queries, but if there is a way to
only view the common information, that would serve my purpose as well.
Thanks.

Nick
Click to expand...
 
Top