Group by Month

[Big Time]

I'm creating a report that tracks calls. Each call has a date when the call
was received. I want to create a report that groups and totals all records
in a given month, however I don't want the individual dates for calls to
show up. What I want to do is basically create a report that shows:

The name of the Month (based on the dates the calls were received)
Total calls

I can get the totals, however how do I get just the month to display?

Thanks.

[rquintal]

Use the year([callreceivedDate]) function*100 plus the
month([callreceivedDate]) function in the underlying query. and group
on that number.

You can also add the month name from the
format([callreceiveddate],"mmmm") function
But that sorts April, December, February.....

[King Ron]

In your query create an expression that calls the Format() function:

example - current month:

MonthName: Format(Now(),"mmmm")

example - where variable "MyDate" is a DateTime:

MonthName: Format([MyDate],"mmmm")

King Ron of Chi

[Big Time]

> Use the year([callreceivedDate]) function*100 plus the

month([callreceivedDate]) function in the underlying query. and group
on that number.

You can also add the month name from the
format([callreceiveddate],"mmmm") function
But that sorts April, December, February.....

Thanks, that did the trick. I created two columns for the month, one so I
could get the long name and the other so I could sort on the numerical value
since as you said, it sorted April, December, February.

[Bob Quintal]

"Big Time" <bi************@remove-for-spam-hotmail.com> wrote in
news:dj**********@nntp.itservices.ubc.ca:

Use the year([callreceivedDate]) function*100 plus the
month([callreceivedDate]) function in the underlying query.
and group on that number.

You can also add the month name from the
format([callreceiveddate],"mmmm") function
But that sorts April, December, February.....

Thanks, that did the trick. I created two columns for the
month, one so I could get the long name and the other so I
could sort on the numerical value since as you said, it sorted
April, December, February.

Hope you cottoned onto the reason for how I defined the numeric
month, to include the year, because after you have accumulated
52 weeks of data, your month totals will get messed up.


--
Bob Quintal

PA is y I've altered my email address.

[Big Time]

Hope you cottoned onto the reason for how I defined the numeric
month, to include the year, because after you have accumulated
52 weeks of data, your month totals will get messed up.

I did, and I appreciate it. I added a year field as well and grouped on
year then month. Thanks again.