Totals in report footer don't work

[AChir]

I'm setting intStandardCount(1 to 4) to zero in my report header and then have the following in On Format for the detail

If FormatCount = 1 Then
Select Case [Ability level]
Case Is = "B"
intStandardcount(1) = intStandardcount(1) + 1
Case Is = "I"
intStandardcount(2) = intStandardcount(2) + 1
Case Is = "A"
intStandardcount(3) = intStandardcount(3) + 1
Case Else
intStandardcount(4) = intStandardcount(4) + 1
End Select
End If

I then use the totals in the report footer, but they are wrong... I have tried tweaking it to make the totals correct (they are all too big by a factor of about 25%) but to no avail. Any thoughts, please? Thanks

 

[David R]

One thing that occurs to me is that I believe in some cases using Print Preview on a report can cause totals to whack out and become doubled. That may be what's occurring here.

 

[David R]

Can't you just use Group On Each Value to get these totals? Sorry I didn't look very closely at what you were doing the first time.
I have a report that summarizes by Council District recent activity. In Design View of your report, View>Sorting and Grouping, turn on either Group Footer or Group Header (your preference), and Group On: Each Value. You'll need to group your data by [Ability Level] of course. Then put an Unbound text box in your header/footer with this as the Control Source: =Count([Ability Level]).

HTH
David R.

 

[AChir]

Thanks - that was an interesting that I can use elsewhere. The trouble is in the example I gave, I need the list alphabetical by surname and can't have it grouped by [Ability level].