group record by months

[Compufreak]

Hi everyone

i would like to know if it possible to group months, here is what i have so far :

SELECT Source.ID, Clusters.Cluster_Desc, Department.Dept_Desc, DatePart('m',Source.Day_Month_Year) AS [Month], Source.Original_Source, Source.Headline, Source.Issue, Source.Analysis, Source.Action
FROM Source INNER JOIN (Department INNER JOIN (Clusters INNER JOIN Cluster_Dept ON Clusters.Cluster_ID = Cluster_Dept.Cluster_ID) ON Department.Dept_ID = Cluster_Dept.Dept_ID) ON Source.ID = Cluster_Dept.ID
GROUP BY Source.ID, Clusters.Cluster_Desc, Department.Dept_Desc, Source.Original_Source, Source.Headline, Source.Issue, Source.Analysis, Source.Action, Source.Day_Month_Year;

basically what i want is for all relevant articles for that particular month to show within that month

thanks in advance

[recyan]

Have you tried instead of

Group By
.....
.....
Source.Day_Month_Year

in your query as

Group By
.....
.....
DatePart('m',Source.Day_Month_Year)

or [Month]

Also, perhaps in a report, you should be able to group by [Month](Would suggest different Name such as TheMonth,etc) the results of the query.

Thanks

[Compufreak]

the results will be displayed in a graph , and based on a start date and end date and a combo box selection. the changes that you told me about now i had just did before your reply. now what i am trying to do is group the I.D as i am noticing that there can 7 articles for a particular department but on different days but within that particular Month. any ideas?

[recyan]

Not in to reports, graphs. Just hold on till some one comes along.
Meanwhile, would suggest posting a few dummy data along with the results you want out of it.
Should make it easier for some one to help the first time round.

Thanks