>hi all,
>I need to select out some data from a table but i am having a problem getting the syntax correct, i don't know if what i am trying to do is possible in one statement. I have a table that has data including depots and on site locations where work will be done. What i need to do is select out from the table where a date field is equal to a form property and then group by depot and then by day within depot and finally sort by time within day
>in pseudocode something like,
>

>sele * ;
>    from table 1 ;
>    where week(dateofwork) = thisform.currweekno ;
>    group by depot, subgroup by CDOW(dateofwork) ;
>    order by depot, suborder by time under day
>

>
>I need the final table to look something like
>

>DEPOT     SUN          MON            TUE          WED...
>__________________________________________________________________
>DUBLIN    9  Finglas   9.30 CITY      10 Dublin7   9.30  Dublin8
>DUBLIN    11 CITY      12   Skerries  11 Bray      10.30 Wicklow
>
>CORK      9  Cobh      10.30 Cobh     8  Kerry     11.30 Town
>CORK      10 TOWN      12    Yaughal  10 City      13    Clonakilty
>

>Slán
>~M

SELECT Depot, DateOfWork, CDOW(DateOfWork) as Day, Time ;
  FROM Table1 ;
 WHERE WEEK(DateOfWork) = ThisForm.txtCurrWeekNo.Value ;
 ORDER BY Depot, DateOfWork, Time ;
  INTO CURSOR WorkSched

This will get your data into the order you want but it won't look the way you have it above.

HTH,