Why not save the UNION query, then make a separate make-table query based on
that. Better yet, create a table to receive the results, or clear it if it
already exists, and append it. Appending a table gives you much better
control over what happens.
Tom Ellison
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.