DCount Problem

[Brogrim]

I am trying to count a Yes/No [Home] value in a table called tblMemPOM. It should count the MemberID

=Abs(DCount("[MemberID]","tblMemPOM",[Home]=-1))

All help much appreciated.

 

[JerryKlmns]

DCount("[MemberID]","tblMemPOM","[Home]=-1")

I believe that DCount returns [always] non negative numbers!

 

[Zion7]

I think Jerry hit the nail on the head.
If MemberID has any Null values, which I'm assuming no, those records will not be included in count.
Should always use Primary Key, for DCOunt.
...in case you didn't, but, I think you did.

 

[Brogrim]

Thanks Jerry and Zion 7, everything working fine.