multiple queries for one report...

[doran_doran]

Download the database from following location...
http://dbforums.com/attachment.php?postid=3335580

I have four queries counting type and basically i am doing this to show summary on a report. Is there a way i can put all this query on one report.?

Report goes like this.

Summary:
- Total Received after due date (count type qryCenRcvd)
- Total Census for Plan Year End (regular type qryCensusIn)
- Total Census Complete (sum type QryCensusStatus)
- Total Outstanding (sum type QryCensusStatus)

I would like to put all this on one report and I don't know how. Can anyone pls help?

Thanks for helping me.
Regards / Dianna

 

[mark curtis]

1st put a db on with all the queries and tables u refer too????

 

[doran_doran]

Database....

Please download the database from following location...

http://dbforums.com/attachment.php?postid=3335580