Helping with a Query

[jimd1768]

I have a query that shows customer orders. I have a check box to show if a customer has paid or the balance is still outstanding.

I want to show in the query just the orders that are outstanding (haven't been paid)

I am unsure of how to set this criteria in a query.

Any help would be greatly appreciated

 

[Trevor G]

I have a query that shows customer orders. I have a check box to show if a customer has paid or the balance is still outstanding.

I want to show in the query just the orders that are outstanding (haven't been paid)

I am unsure of how to set this criteria in a query.

Any help would be greatly appreciated

To check this out, create a new query based on your table then select the fields

in the criteria for the tick box place in False and in the criteria for the outstanding monies place in not null

 

[jimd1768]

Thank you very much for your help.