Mohhamed,
What type are m.dat1, m.dat2 AND dat. I hope Dat is Field from table


>hi all,
>any idea ,help.
> to fix this code under,
> I want to see only what I choice between to dates but I see all months,
> thanks.
>
>
>

>SET CENTURY on
>SET DATE TO british
>SELECT divi
>m.nam=nam
>m.dat1=thisform.text1.Value  && result is january   2005
>m.dat2=thisform.text2.Value  && result is feb...2005 or any month i choice
>SELECT table1 && error message table1 not found, I need to use it to make index
>INDEX ON dat TO kk
>
> SELECT * from table1 WHERE   (dat between m.dat1 AND m.dat2) AND dvno=VAL(this.Value) and peri=thisform.combo2.value ;
>     into CURSOR xyz
>IF _TALLY > 0
>             report form newtable1 preview
>  ELSE
>        =MESSAGEBOX("Still No Product")
>
>Endif
>

>m.qasem