I have a query which shows the balances of various accounts and the dates to which these balances belong. What I need to be able to do if possible is to reduce the balances down to the latest date for each account id so that the most up to date balance for each account is shown. Is this possible, if so how do i do it...?
