creolejazz
Registered User.
- Local time
- Today, 03:01
- Joined
- Jun 28, 2007
- Messages
- 55
I've got a table that contains people and their attendance records for an annual event. The three attendance related fields are: Attend2008, Attend2009, and Attend2010.
Each field can contain either Yes, No, or be blank. ("Yes means the person attended that year, "no" or <blank> means they did not attend that year.)
How do I design the query so that it finds all those who attended in 2010 but did NOT attend previously? In other words, I want to pull only the records that have YES in the 2010 field but anything other than YES in the other two fields. Make sense?
Any clues appreciated. Thanks.
Each field can contain either Yes, No, or be blank. ("Yes means the person attended that year, "no" or <blank> means they did not attend that year.)
How do I design the query so that it finds all those who attended in 2010 but did NOT attend previously? In other words, I want to pull only the records that have YES in the 2010 field but anything other than YES in the other two fields. Make sense?
Any clues appreciated. Thanks.