DCount function

[Rob.Mills]

This is probably pretty simple and I know when I see the answer it's going to seem obvious to me but I just can't seem to figure it out.

I've written out a DCount function to count all the records in a table that are not null in one specific field. Can't figure out how to write out the criteria.

Here's what I've got:

=DCount("[txtLenderCode]","tblMain","[txtDateComp] is not null")

Suggestions??

 

[smed]

You could create a query which omits the null entries, and then substitute the table name in the dcount statement for the query name.

Also, if you leave the criteria of the statement, I believe it only selects recorder that are not null

ie. =DCount("Field","Table")

Smed

 

[Rob.Mills]

Man I knew the answer would be obvious when I saw it.

Thanks!!