Results 1 to 8 of 8
May 1, 2013, 07:17 #1
- Join Date
- Jan 2006
- 0 Post(s)
- 0 Thread(s)
Query to display 4th option (not specified)
I know the summary is pretty vague, but here's the situation. I'm getting stats from a table of registrants for a regional event. Almost all registrants will be from 1 of 3 provinces but the occasional one might be from somewhere else. I want to count how many from somewhere else (doesn't matter where). The field holds the 2 letter abbreviation of the province.
The pseudo query would be "Select a count of people who didn't come from PE or NS or NB". Any help ?