query to list yes values in a report

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

Guest

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.
 
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
 
Unbelievable! I'd tried using Y, Yes, -1... Thanks heaps for your help and
responding so quickly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need report to only select the "yes" based on month 17
how do I attach a value to a check box in access 2007? 4
Unique values in two fields in query 1
Query Based On "yes/no" Switch in Data Base Table 26
Display all fields that are yes in a table in one box 10
I have two Yes/No fields in a table (ContractorInstall, andInHouseInstall) 3
Access Access Report Works on One Machine but not Another 3
Searching for Records in a Report 1

Back
Top