Changing month # to word

[Dragon]

I have a report based on a query that performs calculations within a monthly
period. The query asks for a 2 digit month.

Is there a way to have the full name of the month come up in the report
header?

 

[Marshall Barton]

I have a report based on a query that performs calculations within a monthly
period. The query asks for a 2 digit month.

Is there a way to have the full name of the month come up in the report
header?

Try using the MonthName function. See VBA Help for details.

 

[Dragon]

I'm not familiar with VBA and the help doesn't have much information.
Could you explain more or point me to some where that has more information?

Dragon

 

[John Spencer]

You should be able to use a control with its source set to
=MonthName([Name of the query Parameter Prompt])



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Dragon]

Thanks! works like a charm!!

Dragon

You should be able to use a control with its source set to
=MonthName([Name of the query Parameter Prompt])



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I'm not familiar with VBA and the help doesn't have much information.
Could you explain more or point me to some where that has more information?

Dragon

 

[Marshall Barton]

There are two Help systems, you get to one from the Access
Window and the other from the VB Editor. You don't need to
know anything about VBA to use the Help system in the VB
Editor. It's where the details of all the built in
functions are listed and explained.