query to find maximum value

J

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!
 
M

Michel Walsh

In SQL view:


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


Vanderghast, Access MVP
 
Top