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