Calculation down a column

[Guest]

I have the fields Quantity, unitPrice, Total. Now I needed to be able to
have subtotal at the end of the totals column. I have tried using the
summary option in the report wizard, it work then. However when i insert that
report as a subreport in my invioce, the subtotal comes up blank. I am also
looking to have that subtotal to be added to another total to make a grand
total.
Any help is accpted and appreciated.
Thanks

 

[John Vinson]

I have the fields Quantity, unitPrice, Total. Now I needed to be able to
have subtotal at the end of the totals column. I have tried using the
summary option in the report wizard, it work then. However when i insert that
report as a subreport in my invioce, the subtotal comes up blank. I am also
looking to have that subtotal to be added to another total to make a grand
total.
Any help is accpted and appreciated.
Thanks

I'd use a Report with the Report Footer made visible (it isn't by
default, use View). Put a textbox on the footer to calculate the
total, and then reference it by control name on the main report to get
the grand total:

Me!subreportname.Report!textboxname



John W. Vinson[MVP]