By Month Report Month Name Question

[Kodama76]

I have a report that I'm trying to build that sorts purchases by month...

So I end up with something along the lines of this:

1/12/02
John Smith 1 unit $4.00
Jane Doe 2 units $8.00

2/20/02
Joe Johnson 1 unit $4.00


...now what I want to do it instead of access randomly picking a date to display out of those in the purchase entries I want it to show the month instead. But when I try setting up a "text box" in the date heading that contains this expression =Format([Exdate_D], "mmmm") I get #ERROR on my report. What exactly am I doing wrong here. All the info I can find on the Format function (what little there is) says that thats all I need.

Any help would be appreciated.

 

[Rich]

Just set the format of the control on the property sheet to mmmm

 

[Kodama76]

Just set the format of the control on the property sheet to mmmm

It works great. Thanks for your help!!!


For those that need that explained a little more:

By going into the properties of the text box and setting my control source back to the date field I wanted to use and changing the Format on the format tab of that property sheet to mmmm my dates have become the word associated with the month (i.e. December where the report used to show 12/1/02).