Query help (using access but can do SQL)
I have a request from a user for a dataset and I am not sure how to get that information. She has asked for "All students with SUB, UNSUB, PLUS, only (no other sources of aid)"
So it is easy enough to get all students with those three items (Like "SUB" or Like "UNSUB" or Like "PLUS") but how can I craft a query that brings in students who only have one of those three? There are dozens of other values in that field. A student can have SUB and one of the other ones (for example).
I can imagine making two queries one with students who got one of those three, and one where I say "Not Like" so I get all the students who got something else. Then I could make a table of everyone from table A who does not appear in table B. Would that work?
Does that even make sense?
Any better ideas?