If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yes/No parameter for selecting either
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. |
#2
|
|||
|
|||
Yes/No parameter for selecting either
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" wrote: 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. |
#3
|
|||
|
|||
Yes/No parameter for selecting either
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" wrote: 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" wrote: 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. |
#4
|
|||
|
|||
Yes/No parameter for selecting either
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" wrote: 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" wrote: 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" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|