HELP!!! Filtering data (Access 97)

Topic

New Reply

I have a large database that keeps track of people attending our training sessions. I have a table of employees, course, and courses attended. I have created a query to pull all the data so I can see who has and has not attended class. I have generated a report that shows when a person is scheduled for class, the name of the class, location, date and whether of not they came to class. If they did not attend, I have it post NO in the margin of the report. As usual, I have people register and not attend many times so they may have 3 entries – two with NO and one with YES. I can filter the people who have never registered but now the CEO wants to know who have a NO only. How can I check to see if there are only “NO”s when a person could have several and then a YES.

Please HELP as soon as possible!!!!!

Thanks,
Deborah

Reply | Quote

Replies

If your attendance field is a Boolean (a Yes/No field), you can create a Totals query that groups by person, and sums the attendance field. In Access, False/No is 0, and Yes/True is -1. So if a person has only No’s, the sum will be 0; if there is at least one Yes, the sum will be unequal to 0. Filter out the persons with only No’s by setting a criterion of 0 on the sum.

Reply | Quote

THANK YOU….THANK YOU……THANK YOU!!!!

Reply | Quote