Monthly Cumulative Reports

[shaggawoo]

Hello from Nova Scotia Canada.

Hi there, Im struggling a bit here and I thought I might seek out some advice. Nice to meet you all.

My situation is that im running a database that records events related to the manufacturing process in our company. Everytime a specific event is logged, there is a date mm/dd/yyyy associated with that. What I'm trying to do is do a monthly report that counts the number of individual events within a given month, groups them together (ie: February), then shows a bar chart showing the number of occurances per month.

I will use a date peramater so they decide how many months are to show up on the report. The trouble is that I dont know how to group the dates into months, then report monthly.

Any advice?

Thanks,

Steve

[MMcCarthy]

Hi Steve

To get the Month number of a date you can use the Month() Function.

Month([DateField])

To get the Month name use MonthName()

You can then count the result. Your query would be something like...

SELECT EventName, MonthName([DateField]), Count([DateField) As NumEvents
FROM TableName
GROUP BY EventName, MonthName([DateField]);