Monthname function

[roadrage]

Hi,

I have several tables that i have joined with relationships. I would like to perform some analysis on the sales. I want to create a query that displays monthly sales, but istead of the date being displayed as, i.e: 2/02/2007 i would like the date to show only the month name i.e. February.

I have managed to do it so that the query will showmonth number sequentially 1-12, but i can't think how to do it for month names? Please help

 

[DCrake]

Simple Software Solutions

CalMonth:Format([MyDate],"mmmm")

Do a search in Access for Formatting Dates

 

[roadrage]

You Sir are a genius!!!

Thanks that works a treat!