How do I write this using ADO.

SELECT MAX(Amount) FROM Table1


What I want is to retrieve the record with the largest number in the Amount field.

Thx