Dates in Reports

  • Thread starter Thread starter Penny
  • Start date Start date
P

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
 
Penny said:
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?
Click to expand...


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

Format(TradeDate, "mmmm")
 
Back
Top