Group by Month

[John Taylor]

Really struggling with this and it will probably be very easy.

I have a table [tbl_issues] that I have recorded "issues". I have also
recorded the date that the issue was reported to me as a medium date
(02-Jan-09)

I want to group the issues by "month" in a query so that I can create a
cross tab and build a graph. Simplky put I want to count all the isues that
occured in Jan, Feb, March etc ..

Is there a simple way that I can group the dates in months rather than their
specific date in a query

Thanks in advance for help

John Taylor

 

[John W. Vinson]

Really struggling with this and it will probably be very easy.

I have a table [tbl_issues] that I have recorded "issues". I have also
recorded the date that the issue was reported to me as a medium date
(02-Jan-09)

I want to group the issues by "month" in a query so that I can create a
cross tab and build a graph. Simplky put I want to count all the isues that
occured in Jan, Feb, March etc ..

Is there a simple way that I can group the dates in months rather than their
specific date in a query

Thanks in advance for help

John Taylor

Yes. Put a calculated field in the query by typing (for example)

TheMonth: Format([datefield], "yyyy-mm")

This will extract just the year and month from the datefield, e.g. 2008-12,
2009-01; this format will sort chronologically so you can use it in a Group By
query.

 

[John Taylor]

Thanks John


John Taylor

Really struggling with this and it will probably be very easy.

I have a table [tbl_issues] that I have recorded "issues". I have also
recorded the date that the issue was reported to me as a medium date
(02-Jan-09)

I want to group the issues by "month" in a query so that I can create a
cross tab and build a graph. Simplky put I want to count all the isues
that
occured in Jan, Feb, March etc ..

Is there a simple way that I can group the dates in months rather than
their
specific date in a query

Thanks in advance for help

John Taylor

Yes. Put a calculated field in the query by typing (for example)

TheMonth: Format([datefield], "yyyy-mm")

This will extract just the year and month from the datefield, e.g.
2008-12,
2009-01; this format will sort chronologically so you can use it in a
Group By
query.