Full Version: Display month name in text form based on a date field
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
Javiator
Hello,

I'm working with a report built on a query, and would like to group on month name. My query involves events that take place over several days, so there are StartDate and EndDate fields already included. How do I create a query field that will display month names spelled out textually? That is, if an event starts on 1/1/2010, I would like a field to automatically display "January." Please include any necessary syntax, as I am a fairly new user.

Thank you!
RAZMaddaz
Format([YourFieldName],"MMMM")
Javiator
Thanks, RAZMaddaz, that's exactly what I needed!
RAZMaddaz
Awesome!!! Glad I could help!!!

RAZ
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.