Need help with report

[dce719]

I need help designing a report that will show the "Grand Total" from different queries all on one page. I have tried several times to create one in design view or with the wizard but after selecting the source information from the 1st query a new report design or wizard opens up for the next query as the source. Any help will be appreciated.

 

[ipr1]

Have you tried creating a series of queries and then basing the report on the results of the last query? For example, create query 1 and get the results of the product from that query. Next create query2 and join the fields that are common to both. Query 2 will yield the results from queries 1 and 2, etc.

The final query wikll have the combined results of all preceding queries and the report can be based on it.

(Of course, the easiest way to accomplish the end result is to create a union query and base the report on it).

I hope my explanation helps.

 

[dce719]

Thanks for your help.