Yes/No in Access query

September 2, 2010 at 17:40:56
Specs: Windows XP
I have yes/no in one access table field. run query and can get records with yes, or No by putting =yes, or =no in the query criterai. Now the question is, if I put a ? mark in the query criteria and run query and then put Yes, or No in the Enter Parameter Value window it doesn't work. any ideasd

See More: Yes/No in Access query

Report •


#1
September 3, 2010 at 06:27:31
Do you want it to prompt you for a Yes/No Parameter every time you run the query? If so, in your Criteria row of your Yes/No column, enter "= [Enter Yes or No]

Report •

#2
September 3, 2010 at 17:43:44
I didn't catch my mistake before... It should be "= [Enter Yes or No]" without the "" at the beginning and the end. Sorry about that. I hope that answers your question!

Report •

#3
September 4, 2010 at 07:12:56
thanks for your reply, I found the solution as follows:
- go to query design view
- click on Parameters top right corner of the design window
-type parameter name and then type Yes/No for the data type
-type the same parameter name in the query criteria under the appropriate field
- run query then typing either yes, or no will now work ok

cheers


Report •

Related Solutions

#4
September 4, 2010 at 11:54:36
I'm glad you figured it out. Both ways work, just a different way of doing it! Good luck with your database!

Report •


Ask Question