Writing a query to find 'Last Audit Date'

[t3nchi]

How do I write a query to find the last audit date?

Let's say the table looks like this (year,company,audit date):

2004, Company1, 6/3/2004
2005, Company2, 2/2/2005
2006, Company3, 3/7/2006
2008, Company4, 3/2/2008

Let's say I want to add a new record (in the year 2010) and pull up the last audit date. How do I do that?

 

[Murli]

Use the Group By in your query and max on the date field.

 

[t3nchi]

Thanks Murli.