Counting Records

[Monguse]

Can anyone give me some help on how to count the number of records in an Access Table?
I am rewritting the search routines and need to know the total number of records in order to do the search faster.

Thanks "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson

WebMaster:

http://www.firearms-for-us.com

 

[CasperTFG]

what kind of DB connection are you using. Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow

 

[Monguse]

Sorry I did forget to say, I am using ADO and the Access Table is indexed. "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson

WebMaster:

http://www.firearms-for-us.com

 

[claws2rip]

try this

select count(MyTable.CustomerID) as CountCustID
From MyTable

Sam

 

[CasperTFG]

If you have all the records in an ADO recordest, it's as simple as (if rs is the Recordset name):
[tt]
rs.RecordCount
[/tt] Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow

 

[CCLINT]

But to get an accurate count do a rs.MoveLast
Also, RecordCount will not work on ForwardOnly or Dynamic cursors.

If you end up using Select Count then do not reference a field and it will be faster:
SELECT COUNT(*) FROM myTable