Have a detail field that is "supposed" to increment by '1' for each record.

So the last record (which starts at 1, 2, 3 etc...)ends at 9204 BUT the distinct count for this field is only 9192. So there are 12 records missing.

Instead of sifting through nine thousand entries looking at this field to see when it skips is there a way to flag the next detail record to say it skipped?

Eg. Field = 14 at record 14
    Field = 16 at record 15

Can Record 15 be flagged somehow as a tip off?

Thanks in advance for postings.