Soniya

This sound like a perfect scenario for a pivot table. Take the option
DataPivot table report and navigate to the sql table or view. This will
bring the data to the pivot table designer.

Drag the Day and Item fields as row fields and then the others as values

Once you have them in as day data right click on the Day header and select
Group. Select Months and if there is more than one year's worth, select
years as well.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Soniya" wrote in message
...
Hi All,

How can I Group data in an Sql query based on month while
the data on the table is based on Date?

For Eg.

Day Item Sales Purchase Amount


TIA
Soniya