Hello everyone!!!
I am trying to create a form to query entries that match certain parameters.
Let's say that I want a client name and ID list and that the yes/no values are 1) likes sports, 2) likes dogs, and 3) likes cats
I have unbound checkboxes on my form and I've been trying two different kinds of code on my query:
The problem I'm encountering is that if, for example, the "likes sports" value is not checked, the "likes dogs" value is checked, and the "likes cats" value is unchecked, instead of giving me just a list of clients who like dogs, it generates a list of clients who don't like sports, like dogs, and don't like cats.
I know there's probably an easy way to write the query criteria but I cannot for the life of me figure our how :banghead::banghead::banghead::banghead::banghead:
HELP PLEASE!!!!!
I am trying to create a form to query entries that match certain parameters.
Let's say that I want a client name and ID list and that the yes/no values are 1) likes sports, 2) likes dogs, and 3) likes cats
I have unbound checkboxes on my form and I've been trying two different kinds of code on my query:
- [Forms]![FormName]![Checkbox] - I've been leaving it as is since Access is supposed to automatically know that it's a yes/no field
- Iif([[Forms]![FormName]![Checkbox]=True,True,False)
The problem I'm encountering is that if, for example, the "likes sports" value is not checked, the "likes dogs" value is checked, and the "likes cats" value is unchecked, instead of giving me just a list of clients who like dogs, it generates a list of clients who don't like sports, like dogs, and don't like cats.
I know there's probably an easy way to write the query criteria but I cannot for the life of me figure our how :banghead::banghead::banghead::banghead::banghead:
HELP PLEASE!!!!!