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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MSACCESS - Sorting report based on field calculated in the report 0
Access Access Report Works on One Machine but not Another 3
Report / Query sums 2
Access Query problem 1
Can't create a report from my query in Access 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Report based on a number of queries 1
Total appointments per agent 2

Back
Top