find not including numbers

[#1]

Hello all
Im new in QV.

I faced some problem and i need your help. let me explain it bit. My table is like

name, range, code
first, 1500-3000, 2
second, 3600-5800, 4
others, , 5

I need to find this range of others and give them others code. range end in 9999.

Regards.

[#2]

HI

Sorry cant get u.

U want the code between the range like 1 to 9999 ah

[#3]

sorry for my bad english.

example i need to find 1-1499, 3001-3599..... and give them other's values.

[#4]

Am i cant explain it or its really hard to do?

[#5]

well now i trying to use if() and peek() to find missing ranges.

[#6]

hello all
Im new in QV and its really give headache.

Im trying to find to missing ranges and i using this script but it seams not working.

Test4:
load if(peek(Postal_start,0)>,'1'
 ,if(peek(Postal_start,0)<>peek(Postal_start,1),peek(Postal_start,0)=peek(Postal_end,0)+1
 ,if(peek(Postal_start,1)<>peek(Postal_start,2),peek(Postal_start,1)=peek(Postal_end,1)+1
 ,if(peek(Postal_start,2)<>peek(Postal_start,3),peek(Postal_start,2)=peek(Postal_end,2)+1
 ,if(peek(Postal_start,3)<>peek(Postal_start,4),peek(Postal_start,3)=peek(Postal_end,3)+1))))) as missing_postal_start

Please correct this.

[#7]

Im working on this issue for 3 day now and finally i think i got answer.

The answer is in MappingRanges.qvw in Rob Wunderlich's coockbook.