Search through a table to find largest number

[jodilyn]

hi
i need to search through a table to find the last entered record. the records are autonumbered under the "ID" so the last record entered should have the largert "ID" number.

i am using ado. is there a maximum function i could use???
ex: max(recordset.fields("ID")

or do i need to do something with an array?

Thanks!
jodilyn

[Nias]

How about something like


rs.movelast

(rs being your recordset)

[*Vince]

Hi, try this...


"SELECT MAX(ID) as MaxValue FROM Table"

don't do this movelast thing because the RS will have to retreive all records before going to the last one...