Re: Massive Summary of data

Greetings,

It sounds like you dont want to report on all of the data that is being
returned by your queries. Just a shot here, but if this is the case,
then I would dump all of the data from each query into one common table
and:

DoCmd.RunSql "Insert Into Common(commonIDfld, ID fld, ServiceRepID)
Select 'ProductID', ProductID, ServiceRepID from Query1"

DoCmd.RunSql "Insert Into Common(commonIDfld, IDfld, ServiceRepID)
Select 'IssueID', IssueID, ServiceRepID from Query2"

...

Then query this commone table and pick out the data that you want to
report on

Select top 10 * from Common Where commonIDfld = 'ProductID'
Order By CommonIDfld

Select top 10 * from Common Where commonIDfld = 'IssueID'
Order By CommonIDfld

and you can dump this into another table for reporting.


Rich

*** Sent via Developersdex http://www.developersdex.com ***