thank you ,
>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
>>>