Need help with count query with criteria - Stumped!

[Guest]

I am tracking medical student attendance at daily lectures. I established a
text field in which to track a student's attendance at the lecture with the
first initial of day name and date as field name. If they were in attendance
I put "Y" in the field if they were not there I put an "N" in the field. If
they were exempt from attending, I put an "E" in the field. I can't remember
how to set up an expression to develop an overall attendance score for a
specified period. I know i need to count fields where the answer is "Y" and
count fields where answer is "N" and then add these and then divide # of days
they attended by the total # of days they were required to be there and
multiple by 100 to get a percentage. I can't seem to figure out how to write
this query. Can you help? I would be so grateful!

 

[Guest]

You could do this with two queries. The first to get the counts, and the
second to do the division. Use the groups and totals for the first query.

 

[Guest]

I established a text field in which to track a student's attendance at the
lecture with the first initial of day name and date as field name.
This sounds like your table structure is a spreadsheet styyle.
Correct me if I am wrong in assuming this is your record layout ---
Student M_11/02/06 F_11/06/06 M_11/11/06 F_11/15/06
Bill Y N Y E
Joe Y E Y N
If it is then you need to change to this ---
Student ClassDate Attend
Bill 11/02/06 Y
Bill 11/06/06 N
Bill 11/11/06 Y
Bill 11/15/06 E
Joe 11/02/06 Y
Joe 11/06/06 E
Joe 11/11/06 Y
Joe 11/15/06 N
Then follow what S. Clark suggested.