Report to use multple queries

R

Rod

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
 
O

Ofer

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]
 
Top