Summarize by Month

  • Thread starter Thread starter TomC
  • Start date Start date
T

TomC

I have a date field with dates in the format 9/23/2004.
Now, I have a requirement to summarize my data by month.
How can I do that? I need to find out how I can use the
Month function to group my data by month.
Thanks for any help you can give me.
Tom
 
How about a calculated field =Month([YourDate]) in your query, and group on
that. You may want, also, to use Format([YourDate],"Mmm") to display the
name of the month.

Larry Linson
Microsoft Access MVP
 
Just a little additional comment, Keep in mind that next
or year's month will give the same result using Larry's
suggested formula. you may want to consider year also.
Fons
-----Original Message-----
How about a calculated field =Month([YourDate]) in your query, and group on
that. You may want, also, to use Format([YourDate],"Mmm") to display the
name of the month.

Larry Linson
Microsoft Access MVP

I have a date field with dates in the format 9/23/2004.
Now, I have a requirement to summarize my data by month.
How can I do that? I need to find out how I can use the
Month function to group my data by month.
Thanks for any help you can give me.
Tom
Click to expand...


.
Click to expand...
 
Back
Top