Convert a number to month

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I have a field with the month number (1-12). How do I
convert, say a 4 to read April in a report/form?

Thanks in advance.

Jerry
 
Try the MonthName() function:

MonthName(4, True) returns Apr

MonthName(4, False) returns April


hth,
 
Or if you're using an older version of Access that doesn't have the
MonthName function in it, try

Format$(DateSerial(2000, MonthNumber, 1), "mmm")
or
Format$(DateSerial(2000, MonthNumber, 1), "mmmm")
 
Back
Top