name the months in query? (Access 2000)

Topic

New Reply

Name the months in the query ?
I have the following function :
Month: Format([InvoiceDate];”yyyy-mm”)
And i receive the totals for each month.In place of the month’name i have the number of the moth, as 2001-01. However i want instead of 2001-01 to have the word january on my query,
instead of 2001-02 to have the word february and so on.Is it possible at all?

Reply | Quote

Replies

Markus: Try this:

Month: Format([InvoiceDate];”yyyy-mmm”)

Reply | Quote