Search through a table to find largest number

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

How about something like


rs.movelast

(rs being your recordset)

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...