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