Rothbard
asked on
Select query in Access 2007
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER