J Juan Tamad Sep 25, 2003 #1 I have a boolean field that I want to count all the records that have True.
W Wayne Morgan Sep 25, 2003 #2 This query will do it, adjust the table and field names. SELECT Count(Table1.A) AS CountOfA FROM Table1 HAVING (((Table1.A)=True)); You may also want to look up the DCount function in the help file.
This query will do it, adjust the table and field names. SELECT Count(Table1.A) AS CountOfA FROM Table1 HAVING (((Table1.A)=True)); You may also want to look up the DCount function in the help file.
