J Jerry May 11, 2004 #1 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
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
C Cheryl Fischer May 11, 2004 #2 Try the MonthName() function: MonthName(4, True) returns Apr MonthName(4, False) returns April hth,
D Douglas J. Steele May 12, 2004 #3 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")
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")