Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DCount Problem

Status
Not open for further replies.
Brogrim

Brogrim

Technical User
Jul 28, 2000
184
IE
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.
 
Sort by date Sort by votes

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

I believe that DCount returns [always] non negative numbers!
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Thanks Jerry and Zion 7, everything working fine.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
958
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
575
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
3K
Andrzejek
Andrzejek
Kennelbloke
  • Locked
  • Question
Wierd DCount issue. Someone please enlighten me. 1
Replies
3
Views
214
combo
combo
Moss100
  • Locked
  • Question
Adodo problem
Replies
7
Views
324
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top