Hi, This should be a simple one, b

[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

 

[UncleCake]

I didn't understand "but I can't find anything that can be entered to display every record." Please restate question.

 

[VivP]

I don't think you can enter anything in a parameter prompt to get all records on a 'yes/no'.

You would need to use a pop-up form with something like a tri-state 'tick box' (or a more user-friendly combo box) to vary the criteria in the query and preserve the possibilty of including all records. Viv Paton
Access Developer