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
 

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