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.
 
Back
Top