Changing month # to word

  • Thread starter Thread starter Dragon
  • Start date Start date
D

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?
 
Dragon said:
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?
Click to expand...


Try using the MonthName function. See VBA Help for details.
 
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
 
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
 
Thanks! works like a charm!!

Dragon

John Spencer said:
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
Click to expand...
Click to expand...
 
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.
 
Back
Top