Newbie Access user here.....
I have a table that contains 8 fields (ID#, grade 1, grade 2, grade 3, grade 4 etc...). The grade fields are either blank or contain a 'Y'. I want to find all ID#s that have 6 or more 'Y' across all the grade fields. For example, records that have 'Y' in grade 1, 2, 3, 5, 6, 7 or grade 1,2,3,4,5,6 or any combination that adds up to 6 or greater should be pulled.
How do I do this?
I have a table that contains 8 fields (ID#, grade 1, grade 2, grade 3, grade 4 etc...). The grade fields are either blank or contain a 'Y'. I want to find all ID#s that have 6 or more 'Y' across all the grade fields. For example, records that have 'Y' in grade 1, 2, 3, 5, 6, 7 or grade 1,2,3,4,5,6 or any combination that adds up to 6 or greater should be pulled.
How do I do this?