Report to use multple queries

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

Guest

Hello,

I have a series of queries which tell me:

Daily appointment totals
Weekly appointment totals
Monthly appointment totals.

I need all of this information for a single paged report. Is there a way to
have a report use multple queries?

Thanks
 
As I posted in your previous post, you can use union query, after you saving
it, you can base the report on one query.

Select Field1, Field2 From [Daily appointment totals] Union
Select Field1, Field2 From [Weekly appointment totals] Union
Select Field1, Field2 From [Monthly appointment totals]
 
Back
Top