Using Yes/No checkboxes in queries

[suzyg]

I've just set up a database in access 2000 and need to do a query on whether a payment has been made. The table field is a yes/no checkbox. Does anyone know how to set the criteria ( I'm not very good at SQL) so that only the unpaid bills are listed?? Please?!

 

[CosmoKramer]

In your criteria, enter any one of the following

Yes
True
-1

 

[ldandy]

If your field is called PAYMENT_PAID in the criteria you should say: NOT PAYMENT_PAID.

 

[CosmoKramer]

.....Or, if the checked box indicates a payment has been made and you're looking for unpaid accounts:

No
False
0