Dates in Reports

[Penny]

I have a text box with a field name of [TradeDate](dates
like 1/1/04, 2/15/04, 3/20/04 and so on). I'm trying to
get the dates on my report by date (1/15/04, 2/15/04)
which I have done and by just the month spelled out
(January, February, March). I have a grouping by Trade
Date and I'm able to get the number of the month (1,2,3)
on the report. How would I get the month spelled out?


Thanks in advance.

Penny

 

[Marshall Barton]

I have a text box with a field name of [TradeDate](dates
like 1/1/04, 2/15/04, 3/20/04 and so on). I'm trying to
get the dates on my report by date (1/15/04, 2/15/04)
which I have done and by just the month spelled out
(January, February, March). I have a grouping by Trade
Date and I'm able to get the number of the month (1,2,3)
on the report. How would I get the month spelled out?

Later versions of Access have a MonthName function, or you
can always use the Format function:

Format(TradeDate, "mmmm")