Using Access 2003 convert numeric month to text for reports

  • Thread starter Thread starter M G Henry
  • Start date Start date
M

M G Henry

Hello everyone,

Looking for a way to create a report using data that has dates
formated as 01/01/2003 ( basically mm/dd/yyyy ) but want to display
on the report sorted under categories ( using a query to sort the
categories ) but printed out as long version of the month. January
2005 etc.

Thanks for the help.
 
You can place a text box on the report based on the date column (call the
text box txtMonth or some such).

the text box can be formatted as:

=(Format([DateCollum],"MMMM, YYYY"))

the above would show

January, 2005

for today's date....
 
You can place a text box on the report based on the date column (call the
text box txtMonth or some such).

the text box can be formatted as:

=(Format([DateCollum],"MMMM, YYYY"))

the above would show

January, 2005

for today's date....
Click to expand...

Perfect, Thanks.
 
Back
Top