Querying yes/no data

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

Guest

I have a database that has yes/no data. I am trying to do a query of only the data that has the checkbox marked. Is there a way to do that? Please realize that I am totally computer illiterate, so very simple English, please. Just pretend your explaining it to a kindergarten, because when it comes to computers that is where I am. Thanks
 
Open a new query in design view. Drag all of the necessary fields, including
your yes/no field to the grid. In the criteria field for the yes/no field
put -1. Run your query.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


grandma1403 said:
I have a database that has yes/no data. I am trying to do a query of only
Click to expand...
the data that has the checkbox marked. Is there a way to do that? Please
realize that I am totally computer illiterate, so very simple English,
please. Just pretend your explaining it to a kindergarten, because when it
comes to computers that is where I am. Thanks
 
Back
Top