Data on from two queries in one report

L

lpdc

How do I use two queries in one report where on query gives a list or items
with amounts, i.e. general ledger transactions. And the other query gives the
total compared to budget for the entire general ledger account. Or what is
the best solution to accomplish this?
 
J

John Vinson

How do I use two queries in one report where on query gives a list or items
with amounts, i.e. general ledger transactions. And the other query gives the
total compared to budget for the entire general ledger account. Or what is
the best solution to accomplish this?
Click to expand...

Probably an unbound Report with two Subreports.

John W. Vinson[MVP]
 
L

lpdc

Could you give an example of how this would work or where I could go to find
an example.
 
J

John Vinson

Could you give an example of how this would work or where I could go to find
an example.
Click to expand...

None come to mind. Just try it - create a Report based on each query;
create a new report, with no table specified; drag each of your
specific reports from the Reports window onto the new report.

John W. Vinson[MVP]
 
Top