thank you vey much,

>>thank yoy fro reply,
>>Wrong syntax for BETWEEN, You nned to use a BETWEEN() function in IIF, not the SQL operator?? ihave no idea
>>
>>help again to fix it,
>>
>>thanks alot
>>
>Instead of:
>

>... IIF(edate BETWEEN DATE() AND GOMONTH(DATE(),+1),1,0) 
>

>
>use
>
>

>... IIF(BETWEEN(edate, DATE(), GOMONTH(DATE(), 1),1,0) 
>