Running Total from a calculated value

S

Samuel

All,
Is there a way to do a running total on a control whose control source
is a calculated field?
There is a groupheader0 in this form.

Example
Sam
Payment: 10.00
Payment: 12.00

Total : 22

Juan
Payment: 15.00

Total: 15.00

The control which displays the payment value is a complex calculated
field based off other items on the report.
It is not possible to do the calculations within the limited
capabilites of MS-Access Query. If it was a SQL Server (no chance of
that happening), I could do the calculations within query using T-SQL
if then statements.

Thanks,
Sam
 
M

Marshall Barton

Samuel said:
Is there a way to do a running total on a control whose control source
is a calculated field?
There is a groupheader0 in this form.

Example
Sam
Payment: 10.00
Payment: 12.00

Total : 22

Juan
Payment: 15.00

Total: 15.00

The control which displays the payment value is a complex calculated
field based off other items on the report.


Report text boxes have a RunningSum property that will do
that.

Add another text box (named txtRunTotal) to the group footer
section and set its control source to this kind of
expression:
=[the total text box name]
and set its RunningSum property to Over All

Then a report footer text box can display the grand total by
using the expression:
=txtRunTotal
 
K

Klatuu

Certainly Jet is not as powerful as SQL Server, but are you aware you can
execute VBA functions from a Jet query? I have found it a way enhance the
calculation power.
 

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

Top