In VB6 I have this code for returning data to a recordset via 2
Selects:

1. Select * from MyTable (98 rows of data are here)
rs.recordcount returns "98"

2. Select count(*) from MyTable
rs.recordcount returns a value of 1 - which is fine
Here, rs!results returns "98" - this is very helpful in other parts of
my app.

Thinking I could just copy the code from VB6 to Access 2003, I did
that.
But in my Access app, I found I cannot use "rs!results".  (also tried
"rs.results" which did not show up in the intellisense)
My select count yields 1 row here too, but I need to return the results
of that count (that shows that 98 rows were counted) like I did in the
VB6 app.

Is there any way in Access to return the results of a select count?

Thanks.