Query help

[paulm]

Hi

I am trying to create a query that will ask you to fill in some information before running. I have used the square brackets, and this works fine with text based criteria. However I have tried the same with a Yes/No field, and it doesn't work.

Can anyone tell me why and what I can do to get it to work?

Regards

Paul

 

[ScottGem]

Parameter queries can be very limiting, that's why I don't use them very much. Instead create a form to supply values as criteria. This can be done using the syntax:

=Forms!formname!controlname

You can refer to the value in a control on an open form this way from any other object.

 

[paulm]

Hi Scott
Thanks for your help, that has helped. The only problem I am having now is still with the Yes/No field.

Can anyone tel me if there is a way of inputing a null value into the Yes/No Field so that the query returns both yes and no records?

Paul