Calculation down a coumn

  • 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
 
Kenard,
In the query behind your report, create a field with...
TotalPrice : (Quantity * Price)
Place the fields [Price], [Quantity], and [TotalPrice] in your detail
section on the report.
In any Group or Report Footer of that report...
=Sum([TotalPrice])
will always yield the correct total for the group... or the whole report.
hth
Al Camp
 
Back
Top