How to Display Month Name

[rishi_375]

Hi,
How can i show Month name using below query?

TRANSFORM Sum([Usage_Cost].[UsageValue]) AS [SumOfThe Value]
SELECT DatePart('m',[Usage_Cost].[BYM]) AS [Month]
FROM Usage_Cost
WHERE [US_Code]=[Forms]![frmUsageChart]![cboCommodity]
GROUP BY DatePart('m',[Usage_Cost].[BYM])

In above query it will show month number. I want to show a Month name. I try to use format function but not success.

Thanks.

 

[dcx693]

Try using the Format function this way:
Format(DatePart('m',[Usage_Cost].[BYM]),"mmmm") AS [Month]

 

[rishi_375]

Hi,
I am tried this function, which is u suggest but it is show Janaury for all month number like 9,10,11.

But i am success to find month name using MonthName function.
I found this function from msdn site.

But Thanks for reply and suggestions.

Once again Thanks.

 

[dcx693]

Oh crud. You're right. Glad you found an answer elsewhere. Just for kicks, I found a much easier way to do it:
Format([Usage_Cost].[BYM],"mmmm") AS [Month]