In a report I need to change a month number to a month name.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to put in the ControlSource field the value:

=Format([BirthdayMonth],"mmm")

where BirthdayMonth is the number of a month and I want to get out the name
of the month. That expression has an invalid syntax.

I have also tried

=MonthName([BirthdayMonth])

but this has a circular reference. What am I missing?
 

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

Similar Threads

Month in title of monthly report 4
Bargain 30GB for £10 a month on a 1 month contract. 4
Concatenate Expression with text string in Report? 2
Number To Month 8
Count Per Month 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
#s to be presented as Months 5
Monthly report and with month in title 1

Back
Top