> Hi to all,
> I have created an sql statement .
> The select part is working ok but when i use the ''where'' clause in order to select two dates.
> I get all sort of errors (error no 11 etc..)
> What i want to do is to have the user enter two dates in a form and then process a report based on these two dates.
> Thanking you in advance.
> Regards
> Mike

Hi Tukayo Mike! :)

try this;

select * from table where thisform.date1.value >= date and thisform.date2.value <= date into cursor Myreport order by date