Kaup, Chester
Chester_Kaup at kindermorgan.com
Sun Feb 28 19:05:08 CST 2010
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