Show only blank check boxes in a query

[SR7133]

tI have a check box named Invoice Paid which I "tick" when a client has paid
their invoice. I want to run a query which only shows the check boxes which
are empty to see clients who have nod paid.

I am very new at this so the more detail as to what to do, the better please.

Thanks in advance

 

[John Spencer]

Under the Invoice Paid field in the criteria "cell" enter
False

That should filter the records to show only those where the Invoice Paid
field is not checked.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Philip Herlihy]

tI have a check box named Invoice Paid which I "tick" when a client has paid
their invoice. I want to run a query which only shows the check boxes which
are empty to see clients who have nod paid.

I am very new at this so the more detail as to what to do, the better please.

Thanks in advance

Two approaches to look at in Help:

1) You can "filter" a table, query (etc). Experiment with "Filter by
Form", where you click the button of that name and enter the criteria
you want to match, using wildcards (* and ?) as appropriate in text
fields. To match unchecked check-boxes, in the filtering view (which
comes up as a single record) check and then un-check the box, to make
sure it isn't going to match either. There's also "Filter by Selection"
which is great for text fields but harder (impossible?) to get working
with check-boxes.

2) Create a query based on the table with a criterion set on the
check-box field (True/False). Tip, to understand what's going on, look
at the SQL view of your query once you have it working.

99) Use File > Backup on your database first - you can change things in
filtered views and (most) queries.

Phil, London

 

[SR7133]

Many thanks for both replies - problem solved and I will try a bit more
experimentation.