Using Access 2003 convert numeric month to text for reports

[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.

 

[Albert D. Kallal]

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....

 

[M G Henry]

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....

Perfect, Thanks.