a formula question

[Former Member]

I have a check# listing report. Just wondering if I can do a formula that will put a * next to the check# that has broken sequence.

Check# CheckDate CheckAmount

100 9/10/08 $100.00

101 9/11/08 $200.00

*104 9/11/09 $300.00

105 9/11/08 $100.00

Any suggestion will be greatly appreciated.

[Former Member]

Thank you very much. It's perfect.

[Former Member]

IF NOT EQUAL TO (PREVIOUS () + 1) then "*" else ""

Create the above formula substituting your check number field for k

NOTE: Use the less than then greater than sign for not equal to rather than NOT EQUAL TO in the above formula. The postings here strip away an actual not equal to sign (less than then greater than).

Edited by: James Terry on Sep 11, 2008 10:24 AM