yes/no parameters in a query

[Kim D]

I am trying to pull records from a query based on whether
or no a payment was made. The payment is listed as a
number value. If I use a simple query and enter yes or no
in the criteria line then it will pull the information
that I am requesting, but if I use a parameter (and the
query parameter box) the yes field does not work, it pulls
NOTHING. I know the simple solution would be to make two
queries but that defeats what I am attempting to do. Can
anyone help me?
Thanks!
Kim

 

[John Vinson]

If I use a simple query and enter yes or no
in the criteria line then it will pull the information
that I am requesting, but if I use a parameter (and the
query parameter box) the yes field does not work, it pulls
NOTHING.

Try using a criterion of True, or -1.