DatePart Diaplay Month

C

Chuck Moore

I have been able to develop a report that displays summary information
attached to each month. I have used DatePart Expr1:
DatePart("m",[dtmAmbulanceAuditDate])to pull out the month from the date but
it only displays the month as a numeral eg "3" for March. It would make the
report more professional if I could display the name of the month instead as
"March". Is there a way to force access to do this on my report.
 
F

fredg

I have been able to develop a report that displays summary information
attached to each month. I have used DatePart Expr1:
DatePart("m",[dtmAmbulanceAuditDate])to pull out the month from the date but
it only displays the month as a numeral eg "3" for March. It would make the
report more professional if I could display the name of the month instead as
"March". Is there a way to force access to do this on my report.
Click to expand...

Why not simply format the date to show just the month name?

Exp1:Format(dtmAmbulanceAuditDate,"mmmm")

or not bother to do it in the query, but directly in the report.
Display the [dtmAmbulanceAuditDate] field in the report and set it's
format property to
mmmm
 
Top