Mohammed,

You are casting column7 as C(10) then proceed to compare column7 with a bunch of VAL(), which are numerical

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