Total cost of all records

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

Guest

How in a report can i add up all the cost of eqach records. I have got a cost
column for each record but i don`t know how to add them up.
Any help would be appreciated.
 
hi,
add a text box to the footer with an identifing lable.
as the text box control source enter
=Sum([yourquery]![yourfield])
 
dk3173 said:
How in a report can i add up all the cost of eqach records. I have got a cost
column for each record but i don`t know how to add them up.
Any help would be appreciated.
Click to expand...

If "Cost" is the name of a Field in the RecordSource of the Report, the
following in the Control Source of a TextBox in the Report Footer should do
what you want:

= Sum([Cost])

Note that you don't need the name of the Query, the RecordSource is assumed
as the data source.

Larry Linson
Microsoft Access MVP
 
Back
Top