Yes/No in Access query

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]

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!

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

I'm glad you figured it out. Both ways work, just a different way of doing it! Good luck with your database!