yes/no parameters in a query

  • Thread starter Thread starter Kim D
  • Start date Start date
K

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
 
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.
Click to expand...

Try using a criterion of True, or -1.
 
Back
Top