Finding unused numbers in a range

[NCBrit]

I have a table that details ranges of account numbers that dealers can apply to their customers. For example:

Dlr StartNum EndNum
1 1 50
2 51 200
3 201 350

I also have a table that details all of the customer accounts. For example:

Cust Acct# Dlr#
1 1 1
2 2 1
...
32 55 2
etc....

I would like to create a report that shows unused account numbers in the customer table for a dealers range as detailed in the dealer table. (example - show all unused account numbers for dealer 2)

Is this even possible?

 

[MichaelRed]

Variations of this appear abundantly throughout these fora. Pleas take advantage of the 'advanced search' capability.




MichaelRed
mlred@verizon.net

 

[NCBrit]

what keywords do you suggest?

 

[MichaelRed]

[sequence | missing] and, of course, combinations and variations.






MichaelRed
mlred@verizon.net