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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Taking the sum between two dates 2
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 4
Combine and Insert query 7
date change 1
Update Query - Want to Update Only the First Match 4
Maximum Value in 2 fields of a record 1
Query to group similar number combinations? 4
maximum values in access query 2

Back
Top