[AccessD] Count of Records Returned by Query

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"))
 




More information about the AccessD mailing list