How can I have record count without using RecordCount function. Is there a way like

Select Count(*) from Tablename

If there is..how can I code this?
starting with

Dim RS As ADODB.Recordset

Set RS = new ADODB.Recordset
RS.Open ....


cecile

The more u read, the more u do not know