Field to small when data formatted as MM/YYYY?

[TheVMan]

I keep getting this error:
The field into which you tried to insert or paste data is not large enough to hold the data. Try inserting or pasting less data.

In my query, I derive the date in the format MM/YYYY. The Query looks like this:
DatePart("m",[Date]) & "/" & DatePart("yyyy",[Date]) AS [Month]

This works great if I just dump it in a report. The thing is, I want to group on this field in the footer. When I enable it for sorting and grouping, it takes 5/2001 and makes it 5/2. Then, when I enable the footer, it gives the error that I mentioned above.

Any insight that can be provided would be greatly appreciated.

V

 

[tlbroadbent]

Datepart return an integer value. That may be causing the error. Change your query to create a string value.

format([date], "mm/yyyyy&quot Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[TheVMan]

I tried this, and the result I got for 5/30/2001 for example looks like this:
05/2001150

Any further suggestions?

V

 

[tlbroadbent]

Sorry, there is an extra "y" in my post. It should read format([date], "mm/yyyy&quot Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker