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 :)?