>Hi,
>
>SELECT sum(IIF(month=1,salest,0)) as Jan, ;
> sum(IIF(month=2,salest,0)) as Feb, ;
> sum(IIF(month=3,salest,0)) as Mar, ;
> sum(IIF(month=4,salest,0)) as Apr, ;
> sum(IIF(month=5,salest,0)) as May, ;
> sum(IIF(month=6,salest,0)) as Jun, ;
> sum(IIF(month=7,salest,0)) as Jul, ;
> sum(IIF(month=8,salest,0)) as Aug, ;
> sum(IIF(month=9,salest,0)) as Sep, ;
> sum(IIF(month=10,salest,0)) as Oct, ;
> sum(IIF(month=11,salest,0)) as Nov, ;
> sum(IIF(month=12,salest,0)) as Dec, ;
> salest ,;
> from table ;
> where year=1997 , ;
> group by province
>

actually my report is similar to this one, but instead of sum(sale), i am having order number and delivery dates.

so one order can have multiple deliveries in a particular month, which is want to show in this sequence

order no, order description, jan, feb, mar....

so below each column delivery dates and quantites of each month will come that also date wise sorted within that month, that means 3 jan will come first in jan column then will come say 15 jan and so on.

can this select statement be modified to produce that output ??