UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Display month name in text form based on a date field    
 
   
Javiator
post Dec 17 2009, 11:01 AM
Post #1

UtterAccess Addict
Posts: 206
From: USA
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!
Go to the top of the page
 
+
RAZMaddaz
post Dec 17 2009, 11:07 AM
Post #2

UtterAccess VIP
Posts: 6,171
From: Bethesda, MD USA
Format([YourFieldName],"MMMM")
Go to the top of the page
 
+
Javiator
post Dec 17 2009, 11:21 AM
Post #3

UtterAccess Addict
Posts: 206
From: USA
Thanks, RAZMaddaz, that's exactly what I needed!
Go to the top of the page
 
+
RAZMaddaz
post Dec 17 2009, 11:32 AM
Post #4

UtterAccess VIP
Posts: 6,171
From: Bethesda, MD USA
Awesome!!! Glad I could help!!!

RAZ
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 01:21 AM