Running Sum on a Continuous View subform

[FredK]

Hi All,
This is a slightly different question than my last.

I have a Continuous View subform designed to look like a Datasheet View
subform, with the following fields:
Units
Unitprice
Subtotal
Tax
Linetotal
Grandtotal

The "Tax" field is a calculated field from the "Subtotal" field:
=[Subtotal]*0.0775
The "Linetotal" field is also a calculated field from the "Subtotal" and
"Tax" fields: =[Tax]+[Subtotal]

There's typically several records in the subform, and I would like to have a
Running Sum of the "Linetotal" field, and have it
display in the "Grandtotal" field. What Expression would I use for a
Running Sum for the "Grandtotal" field?

I've tried =Sum([Linetotal]) and that does not seem to work.

Thanks in advance!
Fred

 

[Guest]

A potential way around this is to base the subform on a query. You can then
include a calculated expression in the query that will do a running sum. This
field can then be added to the subform as a read only field.

It's worth a try.