Sum/total in Access 2002 Reports

[COLSAM]

Cannot figure out how to create report with subtotals and totals of values in
records displayed. Have tried many combinations of display, sort, etc. to no
avail.
Any suggestions?

 

[Duane Hookom]

You can add text boxes to Report or Group Header/Footer sections with
control sources like:
=Sum([MyNumericFieldOrExpression])

 

[COLSAM]

Thank you, I will try your suggestion. As you probably can tell, I am a
novice feeling my way along through trial and error. Is there not a way to
create the sum/total for the report during the report creation using Wizard?

You can add text boxes to Report or Group Header/Footer sections with
control sources like:
=Sum([MyNumericFieldOrExpression])

--
Duane Hookom
MS Access MVP

Cannot figure out how to create report with subtotals and totals of values
in
records displayed. Have tried many combinations of display, sort, etc. to
no
avail.
Any suggestions?

 

[Duane Hookom]

I believe a wizard determine the numeric fields and ask if you want to sum
them. I haven't used a report wizard in many years so I can't be sure. I
start with a clean slate of a report with a record source. I then set my
sorting and grouping while setting group headers and footers. From there, I
add my controls on the report.


--
Duane Hookom
MS Access MVP

Thank you, I will try your suggestion. As you probably can tell, I am a
novice feeling my way along through trial and error. Is there not a way
to
create the sum/total for the report during the report creation using
Wizard?

You can add text boxes to Report or Group Header/Footer sections with
control sources like:
=Sum([MyNumericFieldOrExpression])

--
Duane Hookom
MS Access MVP

Cannot figure out how to create report with subtotals and totals of
values
in
records displayed. Have tried many combinations of display, sort, etc.
to
no
avail.
Any suggestions?