A querie that searches yes/no fields?

  • Thread starter Thread starter justin
  • Start date Start date
J

justin

hello,

how would I go about creating a querie to go through all
of the records in a table, and return those records which
didn't have their yes/no field checked?

thanks
-justin
 
Just build a query with all the fields you want to pull. Under the yes/no
field, put the criteria as...

=false


Rick B
 
Thanks for the quick reply.

-justin

-----Original Message-----
Just build a query with all the fields you want to pull. Under the yes/no
field, put the criteria as...

=false


Rick B





.
Click to expand...
 

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

Evaluate Yes/No Field Based on User Input 7
Split data in field on character return 0
Access Dcount (multiple criteria) 3
Yes / No query problem 4
Delete Query: Could not delete from specified tables 0
Update Query 10
Key violations on Append query - no indexes on table 8
Count text values in a Access Field 0

Back
Top