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

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

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,"*","") ?
Click to expand...

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