EducatorChris
New member
- Local time
- Today, 12:31
- Joined
- Dec 5, 2006
- Messages
- 2
I am setting up a select query to tell me when my employees are past due for competencies. I currently have the Grade column set as a string, so that it can either read their grade or 'EXEMPT' if they have been exempted from testing.
In my query, I have a line that reads (essentially):
WHERE [ME]![Grade]<>'EXEMPT'
However, this kicks out a false for everyone who has a Null string (meaning they haven't taken their first test yet) for [Grade]. I think this because <> compares a null result to 'EXEMPT' and returns null instead of false.
Is there a way around this that doesn't involve putting in a false value in all employee records?
In my query, I have a line that reads (essentially):
WHERE [ME]![Grade]<>'EXEMPT'
However, this kicks out a false for everyone who has a Null string (meaning they haven't taken their first test yet) for [Grade]. I think this because <> compares a null result to 'EXEMPT' and returns null instead of false.
Is there a way around this that doesn't involve putting in a false value in all employee records?