Report question

  • Thread starter Thread starter ttimis
  • Start date Start date
T

ttimis

How can I insert data into a report from more than one query

It looks like a report can have only one data source
and if I want to group ten summary qerys into one it does not fit into one
query
so this looks like a limitation or I'm wrong
 
ttimis said:
How can I insert data into a report from more than one query

It looks like a report can have only one data source
and if I want to group ten summary qerys into one it does not fit into one
query
so this looks like a limitation or I'm wrong
Click to expand...

Sub-Reports?
 
As Rick suggested, Subreports are one option.

If the Fields are of compatible definition in each summary... say a Long ID,
a Text Description, and a Numeric Field (even though they have different
Names), a UNION or UNION ALL Query would be another option.

Larry Linson
Microsoft Access MVP
 
Back
Top