How to find Yes/No Records in a date range

[ijaz1976]

hello everyone!
i am new to acces in my database on a form in have a Yes/No field i need to find all records having No when a date range is enterd by user using between parameter like this:
between [Enter start date] and [Enter end date] but where i put "No" to query only no fields.
thanks in advance

 

[John Big Booty]

To test for "No" or an uncheck check box test for 0 (zero) or False. Checked or "Yes" will return -1 or True.

 

[ijaz1976]

thanks for your reply john please define what would be the expression to accomplish this task. in other words where should i place true or false, 0 or -1 value in this expression.

 

[John Big Booty]

Wherever it is that you previously put "No".

 

[ijaz1976]

thanks john i figured out

 

[John Big Booty]

Good work