Look at previous record in a report and use it to format current r

[Nigel]

I have a report where multiple payments could be made agaisnt a specific line
number,

the invoice detail is kept in one tabel and the invoice payments are kept in
another the relationship is line number and the payments in aother table, I
join them together to complete the invoice line

what happens is that we may get multiple payments on one line so when the
data is returned I see the same billed amount for each line what I am trying
to do is look at the previous record and if it has the same line number I am
going to format text to be white so it doesn't show

any advice
thanks

 

[Nigel]

I browsed around Allan Brownes site and lo and behold he had the perfect
solution which worked perfectly