Record Count

  • Thread starter Thread starter Juan Tamad
  • Start date Start date
J

Juan Tamad

I'm new in Access and I'm trying to count record on a field that has a
boolean type. I just want to find out how many true records are there ?
 
Juan,

Try something like:

SELECT COUNT(*) FROM sometable WHERE booleanColumn=True

-Daran
 
Back
Top