By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

Counting using a Text Box in the Group Footer

P: 8
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
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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

P: 8
It works perfect! You are a genius!! Thanks.
Mar 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.