How to catch the last record before a change?

[Happy YN]

I know that there is a function to look at a previous record and thus identify if there as been a change in a certain field. What I need to do is to catch the last record BEFORE a change. Obviously in a report, once it has moved to the next record, it is too late by then to change a previous one or is there a way that one can force a reformat of the report so one can take appropriate action so as to say highlight the last entry for a particular field before it change
Thanks

 

[Happy YN]

I don't understand fully. Why should grouping help. Again how would I know or rather how would the report know that this is the last record of the group. To be more specific, I would like to calculate the balance of in/out transactions for each date (using a calculated field). Each date has any number of transactions but I only want to show the balance for the last transactin of that date. i.e I would use an expression to determine whether that field should be visible or not exactly like in a bank statement. Hence:

Date,In,Out,Balance
7/7,5,10
,8,40
,100,20,43
8/7,25,50
,75,45,48

 

[Happy YN]

Thanks Pat but that still does not help me. I don't want to have to show a footer for every date with info etc. I want to have it in the body of the report. The footer will do stuff after I'm finished but what I want is to do stuff just before I finish i.e. the balance textbox will be invisible but for the last record of that date it will become visible and then revert back to invisible for the next date

 

[Happy YN]

Thanks Pat I will try and work with your ideas! do you think looking at the recordsetclone for each record would noticeably slow down the report production?