Need help with count query with criteria - Stumped!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
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.
 
Back
Top