Creating A Master Query or Report From Multiple Queries

[rmoreno]

I need help. I have been running 5 reports to gather company information. I then take the data from these 5 reports and manually load them into an Excel spreadsheet to calculate a grand total. I would like to be able to run a query or report within my database to get the same information. I have attached a copy of my spreadsheet for review.

Could someone please review this spreadsheet and help me design an easier method of calculating a grand total.

Thank you in advance

 

[jzwp22]

In order to help you can you give some more information about your table structure and the queries you already have. If possible can you post a zipped copy of your DB with any sensative data removed?

 

[rmoreno]

[SOLVED] Creating a Master Query or Report From Multiple Queries

I want to thank everyone who took the time to view my post. Since posting this problem I have developed code that will allow me to summarize my data at the report level.

Thank You Everyone!!