>lcValue = transform(thisform.Text6.value) >lcValue1 = transform(thisform.Text7.value) >lcValue2 = transform(thisform.Text1.value) >lcValue3 = transform(thisform.Text8.value) >lcValue4 = transform(thisform.Text9.value) >lcValue5 = transform(thisform.Text10.value) >Select column5, column6,; > CAST(Icase(; > VAL(column7) >= VAL(m.lcValue) And VAL(column7) <= VAL(m.lcValue1),VAL(m.lcValue2), ; > column7) As c(10)) As 'column7', ; > count(column5) As total_cfil ; > from test ; > WHERE column6 In ('ÃÝÑÇÏ ','ÔÑßÉ ãÓÇåãÉ','ÔÑßÉ ÚÇÏíÉ ') And VAL(column7) In (val(m.lcValue),val(m.lcValue1),val(m.lcValue3),val(m.lcValue4),val(m.lcValue5 )) ; > group By 1, 2, 3 ; > INTO table mucurt > >>thanks