Counting using a Text Box in the Group Footer

[gardner]

Please help. I am trying to count something in a Group Footer using a Text Box. If what I am doing is not doable, or there is a better way to structure this please tell me. Here is the situation:

This is an attendance report for Summer School ( Students may be enrolled in both a AM session or a PM session and could be absent in one or both.)

I have a report that is Grouped first by Student ID, then by date, in the detail section, I have two text boxes, one is AM Absences and one is PM Absences. Within these boxes can be the values E for (Excused), T for (Tardy), U for (Unexcused) and M for (Medical).

In the Student ID Footer, they would like to see total Excused AM Absences, Total Excused PM Absences, Total Unexcused AM Absences, Total Unexcused PM Absences, ect...........

I was trying to use a text box to basically say if the code was E then Count it in this box. If the code was T, count it in this box, etc.......

[MMcCarthy]

Try this for total Excused AM Absences and if it works then just follow the same rule for the others.

=Sum(IIf([AM Absences]="E",1,0))

Mary

[gardner]

It works perfect! You are a genius!! Thanks.

[MMcCarthy]

It works perfect! You are a genius!! Thanks.

No problem. Glad it worked for you.

Mary