Having problems with using DCOUNT

Nz() returns the value of the first argument if it is not Null so it is a matter of what is in that argument.

Zero will cast to False as a Boolean.

Any numeric value except zero will cast to True.

A string that represents a numeric value will be interpreted as a number and cast as such.

Any string that does not cast to a numeric will cause a type mismatch when compared to a Boolean.
 

Users who are viewing this thread

Back
Top Bottom