Report Wizard: No Summary Options button on Sort Page

[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

 

[Duane Hookom]

Do you have numeric fields in your report's record source?

 

[Guest]

Bingo!! Thank You!! It was text but now it is number and there is my Summary
Option Button.

Do you have numeric fields in your report's record source?

--
Duane Hookom
MS Access MVP
--

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

 

[ody]

Do you have numeric fields in your report's record source?

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