How to use yes/no box to sort records in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort records with a simple yes/no box. I just don't know what
to put in the query so I only get one or the other. I tried 'like yes' and
'like no' but this only excluded all records. It's probably quite simple but
I'm new to this. Any help would be gratly appreciated.
 
To sort a query based on a yes/no field so all the Yes record sort first,
choose:
Ascending
in the Sorting row under your yes/no field. Choosing Descending sorts the No
records first.

To return only the records that have the yes/no box checked, enter this into
the Criteria row under your yes/not field:
True
Entering False returns only the unchecked records.
 
Back
Top