HELP!! Need to filter some data!!!

[DeborahP]

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 that will tell me who has attended class and who has not. 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

 

[Rob.Mills]

You'll need to make a few different queries. First do you know how to setup SELECT DISTINCT queries?

First query: Filter out all entries with 'Yes'
2nd query: Filter out all that have 'No'

Now make another query and add both queries to this one.

Setup an outer join on the names of each query.

Actually you can use the wizard to setup a query that finds all nonmatching values using the above queries.

That should get you started. I'm sure you'll have some questions, though so just let me know.