Summing up a detail section field

  • Thread starter charles.kendricks
  • Start date
C

charles.kendricks

I am trying to print a sum of the values from one control ([RegHours])
in the section footer. There are about 15 records in the detail
section of my report. I created a RegHoursFooter section using the
grouping and sorting tool. In the RegHoursFooter I place a text box,
and in it placed the expression "=Sum([RegHours])". The problem is
that when I run the report I get the control containing my sum
expression after each and every record in the detail section of the
report, instead of only once after the last record in the detail
section. What am I doing wrong??
 
M

Marshall Barton

I am trying to print a sum of the values from one control ([RegHours])
in the section footer. There are about 15 records in the detail
section of my report. I created a RegHoursFooter section using the
grouping and sorting tool. In the RegHoursFooter I place a text box,
and in it placed the expression "=Sum([RegHours])". The problem is
that when I run the report I get the control containing my sum
expression after each and every record in the detail section of the
report, instead of only once after the last record in the detail
section. What am I doing wrong??
Click to expand...


You are grouping on a field that has different values.
That's not a group unless you specify part of the field or
use some kind of interval. It sounds like you don'e really
need a group at all, just put the sum text box in the Report
Footer section.
 
Top