What is the type of the Column5, Column6, Column7 and your textboxes.

>thank you for reply
>i try as below, no errors but no results just zero
>

>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(;
>  VAL(column7) >= VAL(m.lcValue) And VAL(column7) <= VAL(m.lcValue1),VAL(m.lcValue2), ;
>  column7) As c(10)) As 'column7', ;
>  count(column5) As total_cfil ;
>  from test ;
>  WHERE column6 In ('ÃÝÑÇÏ      ','ÔÑßÉ ãÓÇåãÉ','ÔÑßÉ ÚÇÏíÉ ') And VAL(column7) In (val(m.lcValue),val(m.lcValue1),val(m.lcValue3),val(m.lcValue4),val(m.lcValue5 )) ;
>  group By 1, 2, 3 ;
>  INTO table mucurt
> 
>

>thanks