How many?

[BurcBoyar]

I'm using an access database and I need to get the number of records in it without counting them. Can someone help?

Database is like:
(automatic number)- text
(automatic number)- text
(automatic number)- text
...
and so on.

I need to find the ending number.
Thanx for your answers.

 

[link9]

SELECT MAX(fieldName) FROM tableName

 

[BurcBoyar]

Well, i couldn't make it...

Should i use it like:
lastrecord = SELECT MAX(fieldname) from databasename

 

[link9]

If you wanted to get that number into a local variable , then you might use:

dim rs,con,sql,maxNumber
set con = server.createObject("ADODB.Connection&quot
set rs = server.createObject("ADODB.Recordset&quot
sql = "SELECT MAX(fieldName) as maxNum FROM tableName"
con.open connectionStringHere
rs.open sql,con
maxNumber = rs("maxNum&quot
rs.close
con.close
set rs = nothing
set con = nothing
response.write("maxNumber&quot


paul

 

[BurcBoyar]

It worked paul.
Thanx for your help.

 

[cfk]

PROBLEM
the max will work as long as you don't delete any records
i.e.

DB =
1 test
2 test
3 test

SO Max = 3 and total records = 3

now delete the second record

DB =
1 test
3 test

SO Max = 3 and total records = 2

Instead of Max use the Count(*) function

SELECT Count(*) as RecordCount FROM Table

 

[BurcBoyar]

cfk:
Well, i didn't try to delete any record. Thanx for your help anyway. I think I'll need it later.