RecordCount

How do I store in a variable the total number of records in a table.

Thanks.

Hi,

There are several ways to Count the totol record in a table.

Your can use the Recordset ".RecordCount" properties

Example..

CountRecord = RecordsetName.RecordCount

OR

You can use the SQL Select Statement "SELECT COUNT(*) AS TotalCount FROM Table1"

Example..

CountRecord = RecordsetName("TotalCount")

[Edited by tomtan on 09-29-2000 at 11:39 PM]