Data on from two queries in one report

[Guest]

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?

 

[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?

Probably an unbound Report with two Subreports.

John W. Vinson[MVP]

 

[Guest]

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

 

[John Vinson]

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

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]