Group by Month

[jiajian]

Hi

I have a DB with date format "mm-dd-yy". How can I total up all related record in Month e.g Jan02, Feb02...Dec02.

Any sample you can share which I can presented it in graph?

Thanks

jiajian

 

[Fuga]

I think you can use month([yourdatefield]) and group by in a query.

Fuga.

 

[jiajian]

Thanks

I knew about using this. However, it can not differntiate the year if you have different year. E.g Oct02, Nov02, Dec02, Jan03, Feb03...

jiajian

 

[shay]

I knew about using this.

... so why not include year([yourdatefield]) and group on both?

shay

 

[antomack]

Create a new field in your query made up as below and group on it.

Year([YourDateField]) & Format(Month([YourDateField]),"00")

You can use a second field to give the format you want of MMMYY for use on your report/graph.

Format([YourDateField],"MMMYY")