Yes/No parameter for selecting either

  • Thread starter Thread starter Owl
  • Start date Start date
O

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.
 
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)
 
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.

RonaldoOneNil said:
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 said:
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.
Click to expand...
Click to expand...
 
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.

Owl said:
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.

RonaldoOneNil said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top