summing in a report

  • Thread starter Thread starter pht1991
  • Start date Start date
P

pht1991

I have 100 records in a table. Each record has a field with a numeric value
in it. I want to write a report that contains a the sum of the value in all
of these fields. However, I don't want each specific field record to show on
the report.

I am a novice, please spell out your answer/instructions clearly.

Thank you!
 
put the field you want to sum on the report and give it a name

on the report footer (NOT the page footer) create a text field - in it's
properties > Data, Control source type =SUM(NameofTheFieldYouWantTheSumOf).

Run the report to check it.

If it looks ok then go back to the fieldd you want to sum, in it's
properties Format > Visible choose False


Jim Bunton
 
Cool! Thanks a lot!

Jim Bunton said:
put the field you want to sum on the report and give it a name

on the report footer (NOT the page footer) create a text field - in it's
properties > Data, Control source type =SUM(NameofTheFieldYouWantTheSumOf).

Run the report to check it.

If it looks ok then go back to the fieldd you want to sum, in it's
properties Format > Visible choose False


Jim Bunton
Click to expand...
 
Alternatively, you can create a Totals Query to sum that field, and use the
Totals Query as the Record Source of the Report. Or you could use a DSum
domain aggregate function as the Control Source of a Control on an Unbound
Report.

Larry Linson
Microsoft Access MVP
 
Back
Top