summing data in report

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

can a report sum data? or is this something that needs to
be done previously in a query? im trying to sum 4 columns
at the bottom of my report and when i pull in the column
header off my query field list i then put "=sum([title of
query header])". When i then go to run the report it
comes up as "#error". what am i doing wrong?

Thank you for any help you can provide!
mike
 
You may be able to sum in the report or the query. Reports are designed to
sum data. To use the Sum function the item you are summing needs to be a
field so that there is a set of records available to sum. You can't use the
Sum function to sum a calculated control. However, textboxes in reports have
a property that textboxes on forms don't have. You can set them to do a
running sum "Over All" or "Over Group". This option is on the Data tab of
the Properties sheet. One method of handling this is to put a hidden textbox
in the section that you need to do the summing then refer to this textbox in
another calculated textbox elsewhere in the reports, such as in a footer
section.
 
Is your Sum() text box in the report footer or page footer. Totals in a page
footer require extra work.
 
Back
Top