The SQL is:
select max(id) from my_table;
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"gocush" /delete wrote in message
...
I'm using ADO to query an ms Access db. How do I get the highest number
in
the first field: ID which is the primary key, and return it to Excel?