Hi,
I have a register (attendance) with columns as follows:
Name | Yr Grp | Date1 | Date2....| Date 10
What I want to do is count the number of rows where Yr Grp=N (a number) AND where the count of Date1 to Date10 =P (present) is greater than 7. i.e. how many people (each row is a person's...