[AccessD] Record Count for all tables

Reuben Cummings reuben at gfconsultants.com
Tue Mar 11 10:53:17 CDT 2008


I'm not going to write any code, but...
couldn't you loop thru and get a record count for each table and keep a
running total of the record counts
you might also need to account for the table being local or linked if you
only want one of the other.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
> Sent: Tuesday, March 11, 2008 11:33 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Record Count for all tables
>
>
>
> Hello All,
>
> I need to get a record count for all tables.  I'm using Access
> XP.  I thought there was a way to have the documentor output to a
> table...but can't seem to get past the report.  The report has a
> record count but I'd rather not read though 100's of pages and
> write it down.
>
> Any suggestions?
>
> Thanks,
>
> Mark A. Matte
> _________________________________________________________________
> Helping your favorite cause is as easy as instant messaging. You
> IM, we give.
> http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>






More information about the AccessD mailing list