Mohammed,
You have to SELECT ... INTO CURSOR ... and have your grid.RecordSource pointing at the same cursor to see the result in the grid.
Also I'm not sure you are really seeing exactly what you want in the browse. Put some records dated 20/03/2004 and 7/02/2001 into table1. Using month() like you are will show data for every year if the month fits in your range.
>thank you so much, it works,
>could you help me show this result at my grid not at cursour,
>i try as under, i see repeat dat at my grid
>thisform.text25.value=("31/03/2005")
>thisform.text2.value=("01/01/2005")
>
>
> SELECT * FROM table1;
>WHERE BETWEEN(MONTH(table1.dat),MONTH(thisform.text2.Value),MONTH(thisform.text25.Value)) ;
>AND table1.mac1=UPPER(ALLTRIM(thisform.text18.value )) AND table1.TYP=THISFORM.TEXT24.VALUE
>IF _TALLY > 0
>brow
>
>thisform.grid1.Refresh
>