DCount Checkbox

[Garridon]

I am trying to use DCount to count the number of records checked in a checkbox field. This is what I've been using:

DCount("boolFieldName","tblName","boolFieldName=True&quot

I also tried Yes, instead of true, but both show that there are zero records. What am I doing wrong?

Thanks!

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[braindead2]

DCount("boolFieldName","tblName","boolFieldName=-1&quot
DCount("boolFieldName","tblName","boolFieldName=true&quot
DCount("boolFieldName","tblName","boolFieldName=yes&quot
all work

are you replacing the field name and the tbl name with your field and table names????