Hi Mike,

Thanks for all the info. I have this in my code...

StartDate = ctod(THISFORM.txtStartDate.Value)
EndDate = ctod(THISFORM.txtEndDate.Value)

* get the order rejects
SELECT * FROM rejects ;
WHERE daterecv BETWEEN StartDate AND EndDate ;
ORDER BY vendorname, daterecv ;
INTO CURSOR OrderRejects

And my SQL command string stayed the same as before...

Thanks,
Sam