>Hi,
>
>| 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 ??
>
>You lost me. I need to know your data structure and exactly what do you
>want.
>I assume you already posted this information but I don't keep messages
>older
>then one day.
>
>Sorin

Thanks to you all, Finally I found the way and it is very easy, it can be helpful for other persons also which are trying to create such kind of reports, finally i have used this statement :-

select iif(month(date)=1, date, { / / }) as jan, iif(month(date)=2, date, { / / }) as feb from delivery

like that I have created 12 months, and report is perfect and its very fast.

thanks to you all once again for taking your time and helping me.