Month function

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

I have a query that breaks out dates into Months. The month function gives
the months in numbers.

Is there a function that will give me the months in text? (ex. January,
Feburary, etc...)


Also, I would like to make my column headings the spelling of the month.
Is that possible?

Thanks,
Jasper
 
Here are couple of approaches to transform a number into a month name. I'm
sure there are others.

for Jan, Feb, Mar:
MonthName(i) or Format(Dateserial(1,i,1),"mmm")

for January, February, March:
MonthName(i,True) or Format(Dateserial(1,i,1),"mmmm")
 
Check on the MonthName() function.

Your "column headings" implies that you'd use a Crosstabs Query to generate
those columns.

You don't mention your data structure -- it all starts with the data!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I don't see that function. What version do I need to be in? I'm in version
2000.

Thanks,
Jasper
 
Great,

I got it to work!

Now, one more question.

Each column is a month based on a date field. Is it possible to make the
caption the specified month?

Thanks,
Jasper
 
Each column is a month based on a date field. Is it possible to make the
caption the specified month?
Click to expand...

If you have *FIELDS IN YOUR TABLE* named January, February, etc. then your
table design *is wrong*. Please post back with a description of your table.
 
Back
Top