Printing Reports

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

Guest

I have several querries with the same basic information. I'd like to print a
report combining multiple querries...

Example,

WI Yes Yes No
MN No No No
IN Yes No No

Right now I have one querry for each state. How do I combine them into one
report?
 
One option will be, to create a union query that join all the queries into
one query

Select * From Query1Name Union
Select * From Query2Name Union
Select * From Query3Name Union
Select * From Query4Name

And base the report on the new query.
================================
The other option will be to create sub report for each query, and display
all the sub reports on a main report
 
Ofer said:
One option will be, to create a union query that join all the queries into
one query

Select * From Query1Name Union
Select * From Query2Name Union
Select * From Query3Name Union
Select * From Query4Name

And base the report on the new query.
Click to expand...

Although this should work well, it occurs to me to wonder if the
underlying Tables are dissimilar enough to require using a Union Query.

It's possible that the Table for each state could be modified to have
fields that match the fields in the other state Tables, and that they
could all be combined into one Table, in which one field (I suggest a
2-character text field) could identify the state to which each record
belongs.

Then your Query could select the desired records without requiring any
special provisions for any one state, and you'd be able to edit it in
Query Design View.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top