Report Wizard: No Summary Options button on Sort Page

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

Guest

I do not have a Summary Option button on the sorting page in the Report
Wizard. I am trying to sum groups. Since I don't have this summary option
button I have placed a text box in the group footer. Control source set to
=sum([rate]). Running Sum set to Over Group. It sums the first group. The sum
of the next group is the sum of the first plus the second etc for each group.
Looks to me like Running Sum Over All
 
Bingo!! Thank You!! It was text but now it is number and there is my Summary
Option Button.


Duane Hookom said:
Do you have numeric fields in your report's record source?

--
Duane Hookom
MS Access MVP
--

Peggy said:
I do not have a Summary Option button on the sorting page in the Report
Wizard. I am trying to sum groups. Since I don't have this summary option
button I have placed a text box in the group footer. Control source set to
=sum([rate]). Running Sum set to Over Group. It sums the first group. The
sum
of the next group is the sum of the first plus the second etc for each
group.
Looks to me like Running Sum Over All
Click to expand...
Click to expand...
 
Duane Hookom said:
Do you have numeric fields in your report's record source?
Click to expand...
yes i do. I have used it until last year with a summary option. Now even on last years report if i use the wizard with the same data i don't get the summary option
 
Back
Top