Simple Query Question

  • Thread starter Thread starter Amy Grace Thompson
  • Start date Start date
A

Amy Grace Thompson

Hello, all. I'm fairly new to Access and not particularly skilled at
query-building, so I'm afraid I have to ask for help on something that
is probably easier than I'm making it out to be.

I have a combo box on a subform within a form "Individuals" with
Choice 1, Choice 2, Choice 3, Choice 4, Choice 5 and Choice 6. What I
would like is for a query to return to me which of these choices have
NOT been selected for an individual. Is this possible given the way
it is currently set up?

Thank you so much!
 
first make a standalone query that works with the criteria being the combobox
selection; i.e. if combobox in form has selected "Joe" make sure that your
query when run will return "Joe" record.

then modify its criteria by putting a NOT in front of the criteria...if it
is string then NOT LIKE or if a number <>
 
Back
Top