Run Make Table Query on Union Query

[VBA_Newbie79]

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

 

[VBA_Newbie79]

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!