query to list yes values in a report

J

JL

Beginner at work here; I have a table with several yes/no fields,
represented as check boxes. How can I make a query return only those records
for which a particular check box is checked? Cheers.
 
J

J_Goddard via AccessMonster.com

The checkbox is just how the yes/no is displayed. To select only records
where a checkbox is selected, put "True" (no quotes) in the criteria row for
that field in the query.

John
 
J

JL

Unbelievable! I'd tried using Y, Yes, -1... Thanks heaps for your help and
responding so quickly.
 
Top