yes/no parameter

[smiller]

In my chart I have a yes/no field that I would like to set up a query to for. I want the user to be able to input yes or no and then the data be displayed. Whenever I enter yes or no when the prompt comes up, I get an error saying the expression is typed incorrectly or the data is too complex. How do I set it up so the user can select yes or no in some way? thanks

 

[Len Boorman]

Think this may be a True/False twist

Yes/No field is boolean !!!

Try changing the field to Text with values of Yes or No

len

 

[smiller]

I would really like to leave the field in the yes/no or true/false form so when I go into the table or any form I can easily check off the box. I don't want to have to right yes and no every time.
thanks

 

[Len Boorman]

Okay but you need to find exactly where the problem is.

Does the query run okay when you put Yes or No directly into the query criteria

If not try True or False

Or leave the criteria out completedly

Object is to get the query to put out a result so that you can narroe down the problem. It may not be with the Yes/No

Len

 

[smiller]

When I type yes and no directly into the criteria it works. There is only the error when I ask the user to imput yes or no.

 

[Len Boorman]

Can you post the detail of how you are prompting for user input

Len