Asw
asked on
Best way to get a record count
Hi,
What is the quickest way to get a record count from an access table?
Thanks
Asw
What is the quickest way to get a record count from an access table?
Thanks
Asw
ASKER
Is this using ADO?
Thanks
Andy
Thanks
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Running a query against the table based on the following SQL text:
>> Select Count(*) from TableName
You can optionally replace the (*) with a specific field name (although the field should be indexed).
----
Russell