Union Query question

  • Thread starter Thread starter Antavas
  • Start date Start date
A

Antavas

I have 2 parameter queries that I need to combine onto 1 report. It was
suggested that I try a Union query but I have no idea even where to start.
Any advice?
 
Antavas said:
I have 2 parameter queries that I need to combine onto 1 report. It
was suggested that I try a Union query but I have no idea even where
to start. Any advice?
Click to expand...

-create a new query in design view without selecting any tables
-switch to SQL View using the View menu, toolbar button or right-click
context menu
-use this as a template:
select <columns> from query1
union all
select <same number of columns> from query2

Look up union queries in online help
 
I have 2 parameter queries that I need to combine onto 1 report. It was
suggested that I try a Union query but I have no idea even where to start.
Any advice?
Click to expand...

A UNION query may work if the two queries both have the same number of
fields of matching datatypes. Press F1 for Access Help and search for
UNION for a pretty-good description of how to create one.

If the two queries have different "shapes", or if you want the user to
see the two queries as separate lists on the same report page, you may
do better to use one unbound Report with two Subreports, one based on
each query.
 
Back
Top