469,643 Members | 2,064 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

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 25908
missinglinq
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
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.