I have a table in Access 2007 with the following fields: TradeDate, TradeTime, TradePrice. The first two are Date/Time, and the last is a number.
I want to select, for each TradeDate, the record which has the largest TradeTime (i.e. the last trade of the day). How can I do it?