Writing Criteria Expression

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

Guest

When creating a simple query, how do I write a criteria expression that will
retreive only records with a "Yes" value in a field with "Yes/No" data type?
 
= True

--

Ken Snell
<MS ACCESS MVP>

amyfinlay said:
When creating a simple query, how do I write a criteria expression that will
retreive only records with a "Yes" value in a field with "Yes/No" data
Click to expand...
type?
 

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

Access Dcount (multiple criteria) 3
Use In() Expression as Query criteria with guts from Function 1
need help with simple criteria in query 2
Using IIF In Query Criteria 4
Data mismatch error 2
Record Count 2
Retrieving records where yes/no data type is checked 8
Count Yes/No with Criteria 2

Back
Top