>I want to select a range of records by date and group them by weeks.
>Any suggestions ???

Here is some untested code, but I think you will get the idea...

SELECT week(startdate) as wdate, atable.* ;
FROM atable ;
GROUP by 1 ;
INTO CURSOR cResult