Month function

[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

 

[George Nicholson]

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")

 

[Jeff Boyce]

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

 

[Jasper Recto]

I don't see that function. What version do I need to be in? I'm in version
2000.

Thanks,
Jasper

 

[Jasper Recto]

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

 

[Jeff Boyce]

I'm using 2002.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

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

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.