Is there a way to retreive the number or recrods..

kyootepuffy · August 19th, 2003, 09:33 PM

in an access database. I know you can use select count sql statement, but is there any other way to find the number of records using something like len(rs.fields.value) or something.

Thanks:)

kyootepuffy · August 19th, 2003, 10:17 PM

And if i want to use a for loop to loop through the database...
Is there an index that i can use like

For i=0 to number of records in database
If fieldname.record(i).value = "false" then
.... do this
end if
Next

thanks again

Canuck · August 19th, 2003, 10:58 PM

I don't have your book, but I would think that a .movenext might help you out (along the lines of recordset.movenext)?

KenSchaefer · August 20th, 2003, 01:47 AM

http://www.adopenstatic.com/faq/reco...ternatives.asp

You should use something like .GetRows() which allows you to place all your records into an array. You can get the number of records by looking at the UBound() of the array

www.adOpenStatic.com