Continuous Form Subtotal

[luckysarea]

Hi Everyone!!



How do i calculate Total on a continuous form? Please Check out the image for details. Thanks in advance.

[alansidman]

Try using the DSum function
Here is the syntax
http://www.techonthenet.com/access/f...omain/dsum.php

Alan

[luckysarea]

Try using the DSum function
Here is the syntax
http://www.techonthenet.com/access/f...omain/dsum.php

Alan

Thanx Alan for ur help. The DSum function doesnt work. I have made a query which Calculates the "Fine Silver" And "Fine Labour" and then i used the DLookup Function, it still doesn't work. it gives the error #NAME?

DLookup("[Sum Of Fine Silver Charged]", "[Order Fine Silver]", "[Order ID] = [Order ID]")

Whats Wrong Now

[luckysarea]

I got it working!!! Just corrected the DLookup syntax!
Thanx!

[alansidman]

Excellent. Just found another possibility if you are interested.

http://www.databasedev.co.uk/subform-total.html

Alan

[luckysarea]

Thanx Alan... This added to my knowledge.