Searching for data in Yes/No boxes

[Keith Burgess]

Hi,
Can you help me? I am very new to using MS Acess and have just built a very basic DB to store enquiries coming in to Head Office from potential franchisees.
Within this DB I have included a "Yes/No" box with a Title of Live Franchisee.
When an enquiry becomes a franchisee I tick the box as yes.
My question is how do I search for all the "Yes's" so that I can display all the live franchisees.

Best Regards
Keith

 

[mhartman]

Hello:
Make a query with your Yes / No field in it.
In the query design mode, place TRUE in the criteria field of the Yes / No field. Then run the query. This will return all the entries that are checked. ie True.
Regards
Mark

 

[Keith Burgess]

Hello:
Make a query with your Yes / No field in it.
In the query design mode, place TRUE in the criteria field of the Yes / No field. Then run the query. This will return all the entries that are checked. ie True.
Regards
Mark

Hi Mark,

This has worked fine many thanks for your prompt and easy to understand reply

Best regards
Keith

 

[mhartman]

Hello: Your are welcome: Mark