Field too small in report when deriving Month/Year

[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

 

[TheVMan]

One more thing that I'd like to add to this post...
This report works just fine on the machine that I developed it on. It just has problems on the machine it was designed to run on. Same version of Access as well as service release. Thanks.

V

 

[JoeMiller]

Check the regional settings in the COntrol Panel of the two machines for differences. This can play havoc when moving reports around and using built in date formats.

HTH Joe Miller
joe.miller@flotech.net