summing in a report

[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!

 

[Jim Bunton]

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

 

[pht1991]

Cool! Thanks a lot!

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

 

[Larry Linson]

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