Case returns the associated result from the first expression to evaluate as "true". Thus, if "AB" is selected for Week1Day1, the values entered into any of the other fields such as Week1Day2, Week1Day3 have no effect on the value returned in the expression.
The fact that you have multiple fields named Week1Day1, Week1Day2, strongly suggest that you would be better off redesigning your tables/relationships so that this data resides in a related table with 1 field for this data, but different records for the data that you now enter into each of these fields. That design approach will enable much more flexible approaches to you you track and report attendance data.
Thank you very much for your response. The previous gradebook that I had made was a "Flat" design. I did not know at the time how tables and relationships work. I have played with it a bit now so I kind of get it. What I was trying to do is separate the different portions of the gradebook into different tables. For example all my attendance information in one table. All of my fitness testing in another and so on. They were to be related by Primary Key Field of student name.
It is hard because I get so close to figuring it out and then feel like I need to start over. LOL
Would it work any better if I used the Choose function for the pulldown and then it will add to whichever the selection belongs. So that if "MU" is selected then it will add a plus one to the appropriate total?
I was thinking that maybe I am not asking the right question?
How would I set up fields to keep track of the number of selections from pulldown fields.
There are 10 fields associated with a value list that contains Black, Red, White, Purple, Blue, Green. How would I set something that would count the number occurrences of each of those colors?
Results would look like
Black - 2
Red - 3
White - 1
Purple - 1
Blue - 3
Green - 0
Thank you to anyone that can help!
I would use 10 records instead of 10 fields. It then becomes much easier to count how many records have a particular value.