expand number range

[mcginty]

Hi All,

I have a table with 3 fields detailing number ranges:

Number1 ; Number2 ; Qty

Number1 = lowest number in range
Number2 = highest number in range
Qty = number of records in range

a record looks like:

500 ; 599 ; 100
900 ; 998 ; 99

What I need is a unique record for each enrty in the number range, eg: 500, 501, 502..up to 599, based on either lowest & highest or lowest & qty of records.

Any ideas?

 

[M8KWR]

for what reason???

 

[mcginty]

To get the list of order numbers between ranges

 

[mcginty]

Don't worry, got this sorted myself.