Need to create a report of missing numbers in a series

[cyclops]

I am looking to create a report of missing numbers in a series of numbers. An example of this would be:

Record 1: Book1 Issue=1
Record 2: Book1 Issue=2
Record 3: Book1 Issue=4
Record 4: Book1 Issue=10
Record 5: Book2 Issue=3
Record 5: Book2 Issue=5

The maximum number is never consistance and the books will either start with 1 or 0 (only 0 if there was a 0 issue keyed).

Here is what I am looking for in the report:

Book1 missing Issue 3
5-9
Book2 missing Issue 1-2
4

Thanks for your time

 

[MichaelRed]

More than I am willing to contribute 'pro-bono'. If you are willing to settle for "close" and functionally "o.K." you could (perhaps) review thread703-125134 in this same forum. It does somewhat more and somewhat less than " ... what I am looking for in the report: ... ", but it CAN at least get you started down a primrose path.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over