Can query calculate Data for each day of the month?

[tom]

I want a query that will calculate data for each day of
the month. For example, I have a query that will
calculate A/P for any specific day of the month.
This query will list all the open invoices for any particular
day and a report will sum them up.

I want another report that will print the running sum
of A/P for each day of the month. Can this be done?

 

[RBear3]

To get daily sums on a report, you would have to pull all the details, then
use grouping and sorting (combined with totals) to group by day and display
only the group footer (with a total).