hi,
thank you for reply, error message Operator/operand type mismatch

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
>>hi all,
>>
>>i need help
>>if thisform.text1.value=2005
>>
>>i need to change this statment
>> column7 >= '2005' to column7 >= 'thisform.text1.value' ......
>>
>>holl code
>>

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

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