How run a union query that needs a parm?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a union query I need to test, it reads in two other queries each of
which also read in other queries. Each side of the union needs a parameter
which I need to supply. However when I run the query, it does not prompt me
for this parameter, it simply returns no records. How can I test this query?
It is giving me an error on execution but I can't see how to debug it. I'm
getting a 'not found' on a column, though it seems to be there.
 
Try removing the parameters from the underlying queries, and declaring them
in the UNION query instead.
 
You must log in or register to reply here.

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

SUM in a UNION query 2
Run Make Table Query on Union Query 2
Union Query 2
Union query 5
Creating a parameter in a Union Query 2
Setting up query parameter to UNION query by VBA 2
UNION QUERY 2
queries and parm 9

Back
Top