Information received from multiple query on a report?

[dmeid]

I am trying to create a report that needs information from many calculating queries. The reason why I do not create one query to do all my calculations is some calculations create another level of calculations based on the previous query do to grouping, summing etc.

I was wondering if I could use mutiple queries in my report to acquire my various calculated fields to place on the report ? If so how is that done?

If that can't be done....... is there any other suggustions to over come this problem?

 

[Robert Dunstan]

You might find it easier to have sub-reports that are based on your queries. When designing your report you can only assign 1 recordsource.

Generally if report is designed to display data from multiple sources then you would create 1 query as its underlying recordsource and this query can be based on other multiple queries.

HTH
Rob

 

[dmeid]

Thanks so much.........I'll try the concept!