Steve Schapel
miscellany at mvps.org
Sat Feb 27 02:09:42 CST 2010
Arthur,
Sorry, not meaning to be picky. But "it seems you're doing way too much
work". ;-)
There is no purpose served by your Nz() function here. DCount will never
return Null.
Regards
Steve
--------------------------------------------------
From: "Arthur Fuller" <fuller.artful at gmail.com>
Sent: Saturday, February 27, 2010 3:33 AM
> Since this is an Access query as opposed to a SQL Server query, it seems
> you're doing way too much work. Why not just do this:
>
> x = Nz(DCount("*", "yourQueryName", "yourCriteriaIfAny"))