Counting amount of record

rtr1900 · December 1st, 2005, 03:28 AM

Hi,

I have an amount of record and after a while I want to know if there are still some records left which have not been altered. I use the next

sql="SELECT COUNT(*) FROM Table WHERE (Conditions)"
rs.open sql, conn
amount=rs.fields.count

It doenÂ´t work, it always says I have records left, althought when I go to the table there arenÂ´t any left (with thos conditions).

If there is another way, pelase tell me.

Regards and thx,

David

ChrisScott · December 1st, 2005, 06:28 AM

Hi David,

Your code is giving you a count of the fields in your recordset, not the count of the records, try this...

Code:

sql="SELECT COUNT(*) AS recordcount FROM Table WHERE (Conditions)"
rs.open sql, conn
amount=rs("recordcount").Value

HTH,

Chris

rtr1900 · December 1st, 2005, 08:08 AM

Thx Chris!
Just what I have been looking for

David