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

  • Thread starter Thread starter zzamba
  • Start date Start date
Z

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,"*","") ?
 
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"
 
Back
Top