Most current date?

[Dragon]

I am trying to query a table that has two fields; Company and Date.

The table is populated by companies we have audited and the date we did the audit. Companies get audited at least yearly and sometimes more often. So the table will have the same company listed many times with a different date each instance.

I am trying to build a filter that will show me a list of each company (once) and ONLY the most current date they were audited.

Ideas?

Thanks.

 

[Kodo]

SELECT Max(AuditDate) as LastAuditDate from TABLENAME where COMPANY=Companyid