Find Missing Records in Query

  • Thread starter Thread starter Dee
  • Start date Start date
D

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
 
Finally found the information I needed through the knowledge base: ACC: How
to Flag Out-of-Sequence Numbers on a Report

Dee
 
Back
Top