472,119 Members | 990 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

Convert Month Number to Month Name in Report based on query

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.
May 25 '07 #1
2 26293
3,532 Expert 2GB
Use the Format function instead:
Format([Date Completed], "mmmm"))
May 25 '07 #2
That works beautifully! Thank you so much!
May 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Richard Hollenbeck | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.