[AccessD] Count of Records Returned by Query

Thanks for the lesson on DCount. I am always glad to learn something new.

________________________________________
From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel [miscellany at mvps.org]
Sent: Saturday, February 27, 2010 2:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Count of Records Returned by Query

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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com