Calculation down a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top