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

Double-click the gray "Details" bar that runs accross your report. That will bring up the "properties" box for that section. Click the Format tab, set the Visible property to NO.

Hi,

well that just hides all my records. I just want to diplay the most recent one.
The report must show the latest transaction (the one thats from the latest date).

Thanks