469,326 Members | 1,320 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Counting using a Text Box in the Group Footer

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.......
Mar 6 '07 #1
3 1570
MMcCarthy
14,534 Expert Mod 8TB
Try this for total Excused AM Absences and if it works then just follow the same rule for the others.

Expand|Select|Wrap|Line Numbers
  1. =Sum(IIf([AM Absences]="E",1,0))
Mary
Mar 6 '07 #2
It works perfect! You are a genius!! Thanks.
Mar 6 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
It works perfect! You are a genius!! Thanks.
No problem. Glad it worked for you.

Mary
Mar 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Simon Matthews | last post: by
3 posts views Thread by Megan | last post: by
1 post views Thread by mjobrien | last post: by
1 post views Thread by mjobrien | last post: by
18 posts views Thread by ChadDiesel | last post: by
4 posts views Thread by BJ | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.