select max field in ADO

[Tonatiuh]

This functions to me:

SELECT amount FROM table1 WHERE amount IN(SELECT MAX(amount) FROM table1)

I hope this functions for you too.

Good Look!