[AccessD] Record count

Doug Murphy dw-murphy at cox.net
Wed May 25 12:56:10 CDT 2005


How about using Dcount, e.g., if DCount("somefield","yourtable")>0 then do
something.

I know some folks think Domain aggregate functions are slow and probably not
worthy of real programmers, but they are simple to use and work.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Wednesday, May 25, 2005 10:19 AM
To: 'Accessd (E-mail)
Subject: [AccessD] Record count


What is the easiest way in code to determine if a table has at least one
record? TIA

Jim Hale

***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited. If you have received this email
in error please contact the sender and delete the material from any
computer. As a recipient of this email, you are responsible for screening
its contents and the contents of any attachments for the presence of
viruses. No liability is accepted for any damages caused by any virus
transmitted by this email.





More information about the AccessD mailing list