Is there a way to use the previous record value in a formula?

[zzamba]

I've created a report to show checks cleared for a certain month and want to
place an asterik next to a check number which is out of sequence. Is there a
way to use a previous record value in an expression =iif([check
no]-????([check no])<>1,"*","") ?

 

[fredg]

I've created a report to show checks cleared for a certain month and want to
place an asterik next to a check number which is out of sequence. Is there a
way to use a previous record value in an expression =iif([check
no]-????([check no])<>1,"*","") ?

See Microsoft Knowledgebase article:
210234 "How to Flag Out-of-Sequence Numbers on a Report"