>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(; > column7 >= VAL(m.lcValue) And column7 <= VAL(m.lcValue1),VAL(m.lcValue2), ; > column7) As c(10)) As 'column7', ; > count(column5) As total_cfil ; > from test ; > WHERE column6 In ('ÃÝÑÇÏ ','ÔÑßÉ ãÓÇåãÉ','ÔÑßÉ ÚÇÏíÉ ') And column7 In (VAL(m.lcValue),val(lcValue1),val(lcValue3),val(lcValue4),val(lcValue5 )) ; > group By 1, 2, 3 ; > INTO table mucurt > >>thanks
>>>Select column5, column6,; >>> CAST(Icase(; >>> column7 >= '2005' And column7 <= '2006','2005,2006', ; >>> column7) As c(10)) As 'column7', ; >>> count(column5) As total_cfil ; >>> from test ; >>> WHERE column6 In ('ÃÝÑÇÏ ','ÔÑßÉ ãÓÇåãÉ','ÔÑßÉ ÚÇÏíÉ ') And Val(column7) In (2005,2006,2007,2008,2009) ; >>> group By 1, 2, 3 ; >>> INTO table mucurt >>>>>>thanks
>>lcYear = transform(thisform.Text1.value) >> >> >>Select column5, column6,; >> CAST(Icase(; >> column7 >= m.lcValue And column7 <= '2006','2005,2006', ; >> column7) As c(10)) As 'column7', ; >> count(column5) As total_cfil ; >> from test ; >> WHERE column6 In ('ÃÝÑÇÏ ','ÔÑßÉ ãÓÇåãÉ','ÔÑßÉ ÚÇÏíÉ ') And Val(column7) In (2005,2006,2007,2008,2009) ; >> group By 1, 2, 3 ; >> INTO table mucurt >>