Hi all,
I stored month as number and wanted to display it as text.
I have a text box called "MonthYear" on form and report to display month (as text) and year.
Here is my format:
My problem is the month show "January" for most records (I have over 600 records), few showing "December".
Can anyone tell me what was wrong?
Thanks!
I stored month as number and wanted to display it as text.
I have a text box called "MonthYear" on form and report to display month (as text) and year.
Here is my format:
Code:
=Format([Month],"mmmm" & " " & [Year])
Can anyone tell me what was wrong?
Thanks!