query to find maximum value

[JR]

I'm trying to write a query to take two columns from a table:

"identification" and "date"

and return only the latest date for the identification

(there are multiple entries for both identification and date in the table).

Dates are in the format 20050901.

Thanks!

 

[Michel Walsh]

In SQL view:


SELECT identification, MAX(date)
FROM myTable
GROUP BY identification


Vanderghast, Access MVP