Select Count(*) question

[TechBoy]

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.

[james.igoe@gmail.com]

Re: Select Count(*) question

If this is an array, the value should be in the array. No? So...rs(0)

James Igoe
Access/Excel VBA Developer

http://code.comparative-advantage.com/