Calculate Running Sum on Datasheet Veiw Form

F

FredK

I have a Datasheet View form with the following fields:
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]

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
 
M

missinglinq via AccessMonster.com

If your form is truly inDatasheet View yoou cannot do this! Datasheet View
only displays the fields from the underlying table/query, unbound controls
and such are not allowed. If you go into Design View and add controls, they
simply will not appear! You could change your form to Continuous View and
format it to look like Datasheet View; then you could do this sort of thing.
 
F

FredK

Thanks for the reply.
I changed my form to Continuous View and formatted it to look like a
Datasheet View, but still can't get the Running Sum to work.
Any suggestons? I guess I'm not sure what Expression to use.
Thanks again.
Fred
 
Top