Query Trouble

[vivian]

I'm having slight difficulty with one of my queries.

I'm trying to get it to pull up the category typed in , as well as pull up the inventory that is in the store front (based on a check mark)

I want the user to be able to type in which category they want, as well as choose if the inventory is in the store front or not.

In order to get the correct category i have entered

like [Please choose the Category]


Now the trouble is that when i go to pull up the store front, it gives me errors.

like [Please enter yes or no for Store front] (allows the no value to be chosen, but not the yes value)


Any ideas?

Thanks

 

[EMP]

store front (based on a check mark)

Is Store Front a Yes/No field?

A Yes/No field is a numberic field. When checked, its value is stored as -1 (not "Yes"). When unchecked, it is stored as 0 (not "No").