Yes/No

[pbecker13]

I have a Yes/No field in a table, and I want to generate a report that only shows the records that are a yes. I cannot figure this out. Any hlep would be appreciated.

 

[Ron_dK]

Create a query based on your table and put something like this in the query :

SELECT YourTable.YourYesNofield
FROM YourTable
WHERE (((YourTable.YourYesNoField)=Yes));

Then bind your report to that query et voila.

Hth

 

[boblarson]

Go to Queries, click on New / Design mode then add the table in and select the fields you want then in the criteria spot under the Yes/No field that you want to limit by type TRUE.

rak's version will work too, it all depends on which fits your preferences on how you create your queries. I like the QBE grid myself as I don't have to think in SQL terms, but others prefer doing it directly in SQL terms.