G
Guest
Am using Access 2003.
Have created a new field in the db table called “E_Dateâ€. Format is
“General Dateâ€.
Want to extract the month from the field to use in a report. In my query, I
have defined the “DateMonth†as: “DateMonth: DatePart("m",[E_Date])â€
When I print the report, I get the numeric for the month. I.e. January is
month 1, Feb = 2, etc.
I want the full name of the month printed. But when I change the DateMonth
definition to anything other than â€mâ€. I get “#error†on the report.
What don’t I understand here? Any suggestions would be appreciated.
Bob
(e-mail address removed)
Have created a new field in the db table called “E_Dateâ€. Format is
“General Dateâ€.
Want to extract the month from the field to use in a report. In my query, I
have defined the “DateMonth†as: “DateMonth: DatePart("m",[E_Date])â€
When I print the report, I get the numeric for the month. I.e. January is
month 1, Feb = 2, etc.
I want the full name of the month printed. But when I change the DateMonth
definition to anything other than â€mâ€. I get “#error†on the report.
What don’t I understand here? Any suggestions would be appreciated.
Bob
(e-mail address removed)