Skips in a Control Number

[jalverson]

I'm working with EDI data that is logged to a microsoft access database. Each document is controlled by a sequential document number. I need to write a report or query that shows if any of the control numbers are skipped. Each document is a row in a table. For example, over the weekend we received documents 299, 300, and 303. Documents 301 and 302 have not been received. Is there a way to show the skip in the record count? Thanks for the help.

Jeff

 

[HiTechCoach]

Jeff,

check out:

April 2004: Mind the gap, take your time, and how long is a string?

How to find missing numbers in sequences, provide a timing capability in your programs and determine the number of times a given substring occurs in a string.

 

[jalverson]

Thanks for the response. The article provided several solutions for me to try. I will only post a new reply if I run into problems. If you don't hear from me, then I was able to use one of the solutions from the article to solve my problem.

Thanks, again,
Jeff

 

[HiTechCoach]

Jeff,

You're welcome.

Good luck ...