Report Design and Queries

[Sandra]

Do all 6 queries have the same column names?
Yes they do.

Are they based off of the same table or different tables?
Same table.

If they have the same column names, you can create 6
reports, using copy and paste, then go into each report
and change the record source property to use the
specified
query.

How do I change the record source property to a different
query. That would solve my problem.

Thanks!

 

[Les]

After you have created your reports, open the report in
design mode. In upper left hand corner, there is a black
box. Put cursor over it and press right mouse button.
Click on properties. Record source will be a selection
under properties. Change the record source to your query
name.