Convert Month Number to Month Name in Report based on query

[CindySue]

Hello--I've got a query that uses DatePart("m",[Date Completed]) to select records for a particular month, and then a report based on that query. I'd like to be able to create a field in the report that says what month they are for. I can get the month number by using =DatePart("m",[Date Completed]) in a text box, but I can't find a way to convert it to the month name. I've experimented with a couple of things I found in the forum, but I'm not talented enough to get them to work. Any help would be appreciated. Thanks.

[missinglinq]

Use the Format function instead:
Format([Date Completed], "mmmm"))

[CindySue]

That works beautifully! Thank you so much!