Calculating a Invoice Total in the Page Footer of a Report

[04061975]

I have developed a query that will give me all the information that I need to display on my report. Then when I design my report I select that query. Now I have it all laid out where I want it and all that is left is to add up all the record at are on the invoice. Now my problem is with the syntax for the Invoice Total text box in the footer. I have previously calculated the quantity by the unit price this giving me the Nett Price. Now I want to use those Nett Prices to get one grand total. But I just cant seam to get it working. I have tried =DSum(NettPrice), =Sum(NettPrice), Count([NettPrice]), DSum(["NettPrice"],"SearchTaxInvoice&quot

Notes: Is the field containing the Nett Price is NettPrice.
The Query containing the Nett Price is called SearchTaxInvoice.

All thoughts would be much appreciated Thank you

 

[danvlas]

Your grand total is not working because you try to sum a calculated field ([NetPrice] or whatever).
You have to sum the calculation.

Just change
Sum(NetPrice)
with
Sum(Quantity * Price) and it will work. Page Footer is not good. A group footer or the report footer are suitable for this kind of calculation.

Good luck


Daniel Vlas
Systems Consultant