Running Sum on a Continuous View subform

F

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
 
S

scubadiver

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.
 

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