Yes/No parameter for selecting either

[Owl]

I would like to know if it is possible in a query to have a parameter that
will allow the user to select either Yes or No, and if so please supply the
wording.

For simplification of an answer, my Yes/No field is called Closed.

Thanks for any help.

 

[RonaldoOneNil]

If your Yes/No field is actual text then simply enter the below into the
criteria row of the Closed field column in your query

[Enter Yes or No]

If your Yes/No field is a check box then enter the following instead

=IIF([Enter Yes or No]="Yes",True,False)

 

[Owl]

Thannk you so very much Ronaldo. You cannot know how excited I am about this
and how empowered I feel and how many queries, forms and reports it is going
to save me. I am very sorry I only saw this almost a month later. I could
have sworn that I had selected "Notify me of replies", but presumably I
didn't. When I did a search on Owl, I found that there were other questions
which people have replied to, for which I also didn't get an email
notification. I feel very bad, because for as many of my 64 years, as I can
remember, I have always said "Thank you" when somebody has done something for
me.

If your Yes/No field is actual text then simply enter the below into the
criteria row of the Closed field column in your query

[Enter Yes or No]

If your Yes/No field is a check box then enter the following instead

=IIF([Enter Yes or No]="Yes",True,False)

I would like to know if it is possible in a query to have a parameter that
will allow the user to select either Yes or No, and if so please supply the
wording.

For simplification of an answer, my Yes/No field is called Closed.

Thanks for any help.

 

[Owl]

Could I trouble you further with another question, please? How can I enter a
Yes or a No AND have the option for both. Presumably it would be to enter
something in the Or row, but I don't know what. I hope you will see this,
especially as you answered me so long ago.

Thank you for any response, Ronaldo or anyone else who answers.

Thannk you so very much Ronaldo. You cannot know how excited I am about this
and how empowered I feel and how many queries, forms and reports it is going
to save me. I am very sorry I only saw this almost a month later. I could
have sworn that I had selected "Notify me of replies", but presumably I
didn't. When I did a search on Owl, I found that there were other questions
which people have replied to, for which I also didn't get an email
notification. I feel very bad, because for as many of my 64 years, as I can
remember, I have always said "Thank you" when somebody has done something for
me.

If your Yes/No field is actual text then simply enter the below into the
criteria row of the Closed field column in your query

[Enter Yes or No]

If your Yes/No field is a check box then enter the following instead

=IIF([Enter Yes or No]="Yes",True,False)

I would like to know if it is possible in a query to have a parameter that
will allow the user to select either Yes or No, and if so please supply the
wording.

For simplification of an answer, my Yes/No field is called Closed.

Thanks for any help.