Access Reports and Subtotals - Probably really simple solution

[Patonar]

Hi,

I am trying to get a report working with a sub total...

Basically i have a table showing delivery notes: It has fields
deliverySerial (text), delivery date (date), delivery quantity (number)

I want the report to total the sum of the delivery quanities....

I have tried doing this by adding a hidden field in the detail section
with calculation =sum(deliveryQTY) and then in the page footer doing
=sum(txtRunningTotal) but this gives me #Error...

How should i be doing this?

Regards

Andy

 

[Guest]

Hi Andy

Put in the footer

=sum([deliveryQTY])

I assume that deliveryQTY is the name of the field. if not change the above.

Hope this helps

 

[Patonar]

Thanks matey - i did try something simmilar but i put in the page
footer and not the report footer!

It works now anyway - ta muchley!

Hi Andy

Put in the footer

=sum([deliveryQTY])

I assume that deliveryQTY is the name of the field. if not change the above.

Hope this helps


--
Wayne
Manchester, England.
Enjoy whatever it is you do

Hi,

I am trying to get a report working with a sub total...

Basically i have a table showing delivery notes: It has fields
deliverySerial (text), delivery date (date), delivery quantity (number)

I want the report to total the sum of the delivery quanities....

I have tried doing this by adding a hidden field in the detail section
with calculation =sum(deliveryQTY) and then in the page footer doing
=sum(txtRunningTotal) but this gives me #Error...

How should i be doing this?

Regards

Andy