Dcount problem

[Duane Hookom]

I recommend against using domain aggregate functions in reports. However, try:
=DCount("LastName","[tblPositions]","IsNull(LastName) = 0")
Or create a query from tblPositions where LastName is not null. Replace the
table names with the query name
=DCount("*","qselHasLastName")

 

[Jay]

I need a Dcount total.


=DCount("LastName","[tblPositions]","LastName")
Gives me the total records but it counts the nulls too.
I read on google that Dcount does not count nulls.
However, my Dcount is counting nulls.
How do I count only the Is not Null records?

=DCount("LastName","[tblPositions]","LastName = is not null")
This gives me error.

 

[Jay]

I need a Dcount total.


=DCount("LastName","[tblPositions]","LastName")
Gives me the total records but it counts the nulls too.
I read on google that Dcount does not count nulls.
However, my Dcount is counting nulls.
How do I count only the Is not Null records?

=DCount("LastName","[tblPositions]","LastName = is not null")
This gives me error.

I found the problem. I used an update sql and updated with ''
instead of Null.