My question is somewhat convoluted so I will try to be as clear and explicit as possible. What I am trying to do is create a query (or a series of queries) that will return records when the record only meets the criteria. What I mean is, say I have two user profiles, one that has three records, lets say for orders made, and the second has one record, again for orders made.
Ex. Orders
Users Item Color Price A Truck Red $10,000 A Car Blue $5,000 B Boat Green $25,000 A Boat Blue $15,000 C Car Yellow $10,000
If I were to run a query like this:
Select Users, Item
From Orders
Where Item = "Boat"
I would return user A and B. I want to write it in such a way so that I only return user B, because their only record is the record that matches my search criteria. I'm looking for records/users that only match the criteria given. Is there any way to get Access to recognize when there are multiple records in addition to the record it returns and then exclude the result if that's the case?