Recode Table

[timlowe]

Hi, I have a report that runs off an sql query (ODBC)... Im using the Function
MONTH(FIELD) and it returns the Number of the month. How can i get this to show the work "January" instead of the number 1?? any suggestions would really help me out.

Thanks

 

[Treason]

Search the help for the Format Function.

 

[Oy Vey]

Try: MonthName(Month(datevalue))

 

[timlowe]

I tried the MonthName(Month(datevalue))

But it bounces back an error saying "MonthName" is and Invalid Function

 

[timlowe]

I just wanted to thank everyone for their help, After messing with the sql query for a while, i was able to get this to work for me.


DATENAME(Month,e.er_1_date)

 

[Mile-O]

DATENAME(Month,e.er_1_date)

What's that?

What was wrong with the Format() function?

 

[timlowe]

an sql function, MONTH(date) returns the number for the month, and

DATENAME(Month,date) returns the actual month name

 

[timlowe]

I'll have to keep that in mind, im more familiar with sql than i am access.