Dcount Syntax for IsNull Criterion??? 2

[alr0]

Hi All,

I have tried:

DCount("[searchLname]", "prepsearch", "IsNull([SearchLname])")

DCount("[searchLname]", "prepsearch", "[SearchLname]=null")

DCount("[searchLname]", "prepsearch", "Len([SearchLname]) < 1")

...as well as several different concatenations. I could not find specific insturction in the help or knowledgebase.

Is it possible and what is the proper syntax?

Thanks,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[PWise]

dcount("*","prepsearch","SearchLname is null")

 

[alr0]

Thanks pwise,

I would never have tried that! Is there a particulare theory behind that method?

Thanks,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[PHV]

Is there a particulare theory behind that method
Sure: aggregate functions ignore null values unless you use *.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886