Find Missing Records in Query

[Dee]

Hi,

I want to find missing order numbers in a query if possible. The order
numbers are, of course, consecutive. Sometimes for some reason an order may
have not been imported. I need to find these orders, so that I can
re-import them in. Say I have Order #s 18165-18175, how can I find out what
numbers didn't make it in, like 18168 is missing. I have a huge table and
would like to make this an automated process to look for orphaned records
not imported.

The field is [DSO] if that helps.

Thanks,

Dee

 

[Dee]

Finally found the information I needed through the knowledge base: ACC: How
to Flag Out-of-Sequence Numbers on a Report

Dee