Union query

[Guest]

Is it possible to user the results of a union query to build a table? If so
how would I do it?

 

[Guest]

Well you could use the resultset of the union to create a maketable query.
Run that and you are stuck with a table with the results from the unionquery.

Create your union query.
Use the union query as the source for a new query. Change the query to a
maketable query. Run the query and voila behold the table with the union
results. If you run the query over and over again you'll be prompted that the
table already exists and if you want to overwrite it.

hth

 

[John Spencer]

Yes.

Write the union query and save it.

Open a new query and as the source for the new query use the saved Union
query.
Now, turn the new query into a maketable query by selecting Make Table from
the Queries menu.
Then choose Queries: Run from the menu to create the table you want.

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

 

[Guest]

Thank you, I did that and it works great.