I have a table where i enter all my transactions and then use a query to differentiate and calculate the final result. the query alculates for each transaction and gives me the final result but with an entry for each transaction.
each of these calculated by my query is shown in the report. i just want to be able to see the latest avaliable balance and date.
can someone tell me how do i do this please.
thanks
each of these calculated by my query is shown in the report. i just want to be able to see the latest avaliable balance and date.
can someone tell me how do i do this please.
thanks