Convert Month Number to Text

[Smurfit-Stone]

Hello, I have a query and report that prompts the user to enter a month (e.g. 1,2,3 etc) I'd like to add the month in the header of the report created using this query. Currently is shows the month number, but I'd like to change it to text (e.g. 1-January, 2-February, 3-March etc.) would I do this in the query itself or in the properties of the textbox I've placed the formula in on the report......I thought I'd fix it by creating a table with the months listed with a autonumber, but now I dont' know how to add the table to the query expression or to the report textbox.....HELP

 

[Joe4]

Say your month number field is named MonthNum, then in a query, create this calculated field:

MonthName:[MonthNum] & "-" & Format(DateSerial(2005,[MonthNum],1),"mmmm")

This will return what you are looking for.

 

[Smurfit-Stone]

jmiskey, awesome.....Worked like a charm....Thanks a bunch