Find the Max Date where...

[gheyman]

If I had a Table with two columns, the fist column is Letters (A,B,D,D,F,D,E,F,G,H...) and the second is a date for each of these.

Note There could be different dates where there is duplicates (the First F:1/1/2016 the second F:1/5/2016 and so on)

Is there a way to find the Max date for a letter? If I select F, I want the result to be 1/5/2016

Thanks

 

[Joe4]

Aggregate (Totals) Query.

Simply add your two field to a new query.
Then click on the Totals button (looks like a Sigma). This will add a Totals row under each field in the query with the words "Group By" under each one.
Change the "Group By" option under the Date field to Max.
View your results.

This will return the Max date value for each Grouping (and you are just Grouping by your letter column).

Aggregate queries are very useful, so it is a good tool to learn. There are lots of different aggregate functions, MIN, MAX, SUM, AVG, FIRST, LAST, etc.
They can also be used to eliminate duplicates form being returned in a query.

 

[gheyman]

Thanks. That's a great help. Very much appreciated!

 

[Joe4]

You are welcome!