Hi Steve,

Do you want max(invoice_amount) for max(invoice_date) or they are independent? Is there a unique key in this table?

>Hello:
>
>I'm trying to create a sql statement (or series of) that would allow me to identify what vendor record has the max(invoice_date) and max(invoice_amount). Not the aggregate values all of venders. I need to get the max(invoice_amount) because we can have mulitple records with the same invoice date. Invoice number may not be unique in this situation.
>
>I was able to create one sql statement with a subquery to return max(invoice_date) for each vender, but having two max requirements got be bogged down.
>
>
>Regards,
>
>Steve