Getting Totals from five reports to creat one report.

[Czeszyn]

Hello
This might be a hard one. Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals. Is this possible?

Tony

 

[plog]

Yes, you can use a DLOOKUP into the underlying data sources of those 5 reports. Or if the underlying data of the 5 reports are based on the same data source, you could configure a query to give you those totals and use that query as this new Totals report's data source.

 

[Czeszyn]

Are DLOOKUp hard to do, never done one before.

 

[plog]

Here's a good reference page for them. Give it a shot and post back here any issues you have:

http://www.techonthenet.com/access/functions/domain/dlookup.php