Microsoft Access Converting Dates

  • Thread starter Thread starter niceday147
  • Start date Start date
N

niceday147

Hello,

I am a new user to microsoft access and I am having problems transferring
dates into the correct format. The dates appear in tables as 01, 02, 03 etc
for the months. I need these to be displayed in the query results and the
reports as January, February, March etc.

Does anyone know how to do this?

Thanks for your help

Ross
 
Set the Format property of the text box on your report to:
Long Date
or an explicit format such as:
mmmm dd\, yyyy
 
It seems that you have a text field storing the month number. If this is the
case, you can convert this to a month name using the MonthName() function.

=MonthName([YourFieldNameHere])
 
Back
Top