Changing date field to month only field

Hi,

I have lot of transactions, in various months, under different dates. When i make a query, i want the all the dates in a month to be named after that specific month.

Example:

11/15/2004 - Should read as november,2004

11/16/2004 - should read as november, 2004.

12/06/2004 - shoud read as december, 2004

This would help me in report, so that i can group them by month and get the overall transaction values.

Can any one help me.

Iwells, you seem to be guru. I tried the above reply u wrote to Kat. That gives me only for the current month. Can you please extend it to all months.

Thankyou

Hi Rishyraj,

I had posted this under the other thread to Kat,

In your query make a new expression and give it whatever name you like:

Format([YourDate],"mmmm" & " " & "yyyy") Gives Month and Year with a space between them
Format([YourDate],"mmmm" & ", " & "yyyy") Gives Month and Year with a comma between them

In your report group by the name you have given this expression.

lwells

I got success in grouping by month in the report with your help. But now, the grouping is in alphabetical order, due to which the months are not lined in.

for example..

December 2004

Febrauary 2004

January 2004

Please advise.

Thank you

Rishy

Create another expression Format([YourDate],"mm") this will give you the months in a number...Jan =1, Feb =2 and so forth. Then set the column to ascending.

lwells

Iwells, thank you again. Your advise helped me, But again u know, one problem, I had got the dates to number order. There is an exception in the data in am working on. Most of the data pertain to november and december, but one pertains to April 04. So when i am sorting them by month number and year i get the following.

04 05 = April 05
11 04 = Novemeber 04
12 04 = December 04

Where as i want it to be

11 04 = Novemeber 04
12 04 = December 04
04 05 = April 05

The above is the grouping order i am getting in report.

Can you please advise.

Sort by year and then by month

lwells