Date as "month"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a qry based on a table that has a date field; i want to have a column
in the query called 'Month' that displays the month of the date, as the
actual word eg January. currently i have it returning as a number eg "1" for
january... i have this line in the field in design view:

Month: Month([date])

what do i have to add?

Cheers
Chris
 
Chris,

Try this instead:

Month: Format([Date], "mmmm")

By the way, both the Month and Date words are Access reserved keywords
(they are both functions), and it's best to avoid using them as field
names and aliases, as you might confuse Access and get into trouble. Try
using different names.

HTH,
Nikos
 
I use
TheMonth: Format([Date],"mmmm") for the full name
TheMonth: Format([Date],"mmm") for the abbreviated name

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
That works great...thanks very much to all of you

Chris

John Spencer said:
I use
TheMonth: Format([Date],"mmmm") for the full name
TheMonth: Format([Date],"mmm") for the abbreviated name

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

crtopher said:
I have a qry based on a table that has a date field; i want to have a
column
in the query called 'Month' that displays the month of the date, as the
actual word eg January. currently i have it returning as a number eg "1"
for
january... i have this line in the field in design view:

Month: Month([date])

what do i have to add?

Cheers
Chris
Click to expand...
Click to expand...
 
Back
Top