Paid query

[Exoduslow]

Hello, I have another problem with another of my queries. I want to create a query where if the user types in yes then all the paid queries will come up, if they type in no then all the un-paid queries will be shown. I have the Paid field in tickbox boolean format.

Any help would be greatly appreciated, thanks !

 

[SOS]

Why make them type in YES or No, use a form and let them check a box for yes and then you can use that as the criteria in the Paid field.

 

[Exoduslow]

Hey thanks for the reply. It is more of a query to find people who have paid and those who have not. I want to be able to bring up a list of people who have not paid the company.

 

[SOS]

Right, and leaving the checkbox unchecked would do just that if the query referred to that checkbox on the form as the criteria.