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.

 

[Joseph Meehan]

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.

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?

 

[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?

 

[Joseph Meehan]

No, I have never done that.

I am not all that good at writing instructions, especially one something
like this. It is a little complex for a newsgroup.

I suggest you search the help files for reports and subtotals. Look at
the Northwind example and maybe pick up a book on Access.

It is not all that difficult, but there are a lot of ways of making an
error.

It amounts to adding a "control" (sort of a temporary field) to the
report and making in invisible. It must be in a part of the report where
the data you want to total is or would be displayed when run. Then in a
footer you reference that control to display the value. OK I said I was
not good at explaining it.