hi Mark:
I found a way to make the sql works the way I want it to but can you tell me why: if I substitute the cdow(sart) with a date {01/10/2000}, it will work.
Thank you for all your replies.
sherry