query to find maximum value

  • Thread starter Thread starter JR
  • Start date Start date
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!
 
In SQL view:


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


Vanderghast, Access MVP
 
Back
Top