Range data loading [message #8140] |
Tue, 29 July 2003 20:50 |
MM
Messages: 27 Registered: July 2002
|
Junior Member |
|
|
Hi
I am trying to load data based on a range of values. My loading looks similar to the example i'm quoting.
High_range = 0024
Low_range = 0001
Equipment_type = 'SLC2000'
T1 = 1-2
T2 = 1-9 and 14-21
T3 = 1-24
My data looks like this.
High_range Low_range T1 T2 T3
0024 0001 1 2 8
0048 0025 2 3 2
For a given equipment_type between 'High_range' and 'Low_range' I should be loop through each range one by one and for T1's 1 and T2's 2 load T3's 8 to 24 like (8,9,10 ... 24) and for the next ranges and so forth.
I hope i have explained the problem with the example,
Thanks in advance
MM
|
|
|