select query to show greatest dates

[ausmoran]

I have a table in which I have records with the following fields: BoardNumber, ListingDate

Each BoardNumber has numerous records with different listing dates. I am trying to figure out how to develop a query that selects only the most recent LISTINGDATE for each BoardNumber. Is there an easy way to do this?

Thanks in advance!

Austin

 

[TomCologne]

Something like this:

SELECT Max(tblYourTableName.ListingDate) AS MaxOfListingDate, tblYourTableName.BoardNumber
FROM tblChecks
GROUP BY tblYourTableName.BoardNumber;

There's also a "DMax" function, see Help for details.

TomCologne

 

[dhookom]

Select BoardNumber, Max(ListingDate) as GreatestDate
FROM tblBoardListings
GROUP BY BoardNumber;

Duane
MS Access MVP
Find out how to get great answers faq219-2884.