>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