>>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 >>>