How do I test for increments of 1

[geedubcpa]

I have a report that list all the tickets in numerical order for a month. How can i test to see if each number is one more than the previous number on the report.

Row 1 = 2500
if row 2 = 2501 ok
if row 2 = 2503 then i have a problem

Thanks for any ideas.

 

[Turkbear]

Hi,
If sorted in order then you could probably use the Previous function to test - Build a formula ( maybe call it ErrorFlag:

@ErrorFlag
If Previous({table.record.value}) <> ({table_record.value)- 1)
  Then
"We Have a Problem"
else
""

Place it after the field displaying the #..

( you should test as well for the first record, since it will never be = to (current -1))







To Paraphrase:"The Help you get is proportional to the Help you give.."