Run Make Table Query on Union Query



I have a Make Table query that is based on a Union query. It was my
understanding that just running the Make Table query executes the Union
query. However, I am now being told that I need to run the Union query
before I run the Make Table query that is based on that Union query. The
Make Table query results in roughly 300,000 rows and takes a considerable
amount of time to run. I certainly don't want to double that time by having
to run both the Union and Make Table queries seperately. Any advice?

John Spencer

Who is telling you that you have to run the UNION query first? That makes no
sense to me.

When you run the make table query, the Union query should execute as part of
the maketable query. Try it and see what happens. If you get an error or
unexpected results post back with the details of the problem.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County


That was exactly my thought. I haven't received any errors by running the
Make Table query first, so I will just continue that way. Thanks!

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

Similar Threads