calculating results of a query

[Ryan Young]

I would like to take the results of a query (customer orders for a day) and
take a running total of two of the columns in that table (U-pick annd
We-pick) and have these running totals displayed at the bottom of the report
that is generated based on the query. I have the query set up, just not
sure how to create the running total. Part two of this is to pull a figure
from another table (Max #) and have it print that max number on the report
to visually compare against the running total.

Thanks in advance.

 

[Ryan Young]

No, I have never done that.

You can do it in a query, but I think I would just do it in the report.
Do you know how to do totals in a report?