Efficent Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created two queries I created for a report. The first shows the expenses my GL entry for the month. The other one is the same except it does it for YTD. What is the most efficent way to combine the two queries into one so i can display both sets of information one one report.
 
The easiest solution would be to create a 3rd query that
combines the first two and build the report off of the
third query.

Tom
-----Original Message-----
I have created two queries I created for a report. The
Click to expand...
first shows the expenses my GL entry for the month. The
other one is the same except it does it for YTD. What is
the most efficent way to combine the two queries into one
so i can display both sets of information one one report.
 
I have created two queries I created for a report. The first shows the expenses my GL entry for the month. The other one is the same except it does it for YTD. What is the most efficent way to combine the two queries into one so i can display both sets of information one one report.
Click to expand...

Don't. Use a Report with two Subreports, one based on each query.
 
Back
Top