Sum/total in Access 2002 Reports

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

Guest

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?
 
You can add text boxes to Report or Group Header/Footer sections with
control sources like:
=Sum([MyNumericFieldOrExpression])
 
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?

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

--
Duane Hookom
MS Access MVP

COLSAM said:
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?
Click to expand...
Click to expand...
 
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

COLSAM said:
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?

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

--
Duane Hookom
MS Access MVP

COLSAM said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top