Strange results from a parameter query

[trystanhuwwilliams]

Hi,
This should be a simple one, but i can't seem to work this one out. I'm running a parameter query which prompts on a YES/NO field. If you enter "yes" or "no" the query produces an error message. However it will accept -1 for "yes" and 0 for "no", but I can't find anything that can be entered to display every record.

Can someone help please?

Thanks in advance

 

[scroce]

Have you tried going into the table design view in which the field resides, click into that particular y/n field in the design view, and then look at the bottom part of the screen on the 'general' tab. On the 'format' property, there are 3 choices 'yes/no', 'true/false', and 'on/off' - I believe whatever that is set to is what it will accept. - It's probably stick on 'on/off' try setting it to 'yes/no' Seek not outside yourself; heaven is within.

 

[trystanhuwwilliams]

Hi,
I'm afraid that doesn't work either,
Thanks for the advice,

 

[scroce]

ok, maybe try something like this:

[Enter yes or no] Or [enter yes or no] Is Null

put this under the criteria of the query. If you want all records, then just leave it blank. Seek not outside yourself; heaven is within.