Working with outside query totals in a report

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

Guest

I have a report based on a query, but I need a calculation based on results
from two other queries. Both the queries are grouped by date, so they have
the same number of entries. I am trying to divide one number in one query by
another number in another query, for each date, and have that result show in
a detail footer (also sorted by date) in my report. Thank you.
 
I have a report based on a query, but I need a calculation based on results
from two other queries. Both the queries are grouped by date, so they have
the same number of entries. I am trying to divide one number in one query by
another number in another query, for each date, and have that result show in
a detail footer (also sorted by date) in my report. Thank you.
Click to expand...

Create a third query, joining the two queries by date. Put your
division as a calculated field. Base your report on this query.

John W. Vinson[MVP]
 
Back
Top