Monthly report and with month in title

C

charkey

I am trying to run a monthly report where I can display the month name in the
title. I can get the value for the month (5 for May) to display but how do I
change that the the month name "May"? Can I use an array? Below is the
array I would like to use.
Dim qcmonth
qcmonth = Array(“Januaryâ€, “Februaryâ€, “Marchâ€, “Aprilâ€, “Mayâ€, “Juneâ€,
“Julyâ€, “Augustâ€, “Septemberâ€, “Octoberâ€, “Novemberâ€, “Decemberâ€)

Where and how do I have that to show up in the title?
 
D

Duane Hookom

If you have the month number in the report's record source or someplace,
simply set the control source of a text box to something like:
=MonthName([Month Number])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top