dcount criteria

[markjkubicki]

I'm trying to determine if there are any records in a table where a particular field has an entry:

        vCntDetail = DCount("[Tag]", "tbeTagDetails", Len([Reqmnt_Detail]) > 0)

Instead it returns the number of records (total in the table.)
my hunch is that I can't use a function in the dCount() criteria (or at least not in this manner ?)

any thoughts, comments or suggestions will be greatly appreciated in advance,
mark

[orange]

You might try
vCntDetail = DCount("[Tag]", "tbeTagDetails", "Len([Reqmnt_Detail]) > 0" )
Examples at
https://www.techonthenet.com/access/...ain/dcount.php

A sample from one of my tables:

?dcount("*","ComparisonOutput","len(datatype1)>0")
 2

[markjkubicki]

BANG . that was it

("..whens all else fails, check the obvious")

thnx