Months query (Access 2000)

Topic

New Reply

In my query the number of the months is shown with figures for example 1 for january etc. Can i convert these numbers into words, say january instead of 1 ?

Reply | Quote

Replies

I assume that you have a date field in your query, and a calculated column looking like

M: Month([DateField])

For display purposes, use the date field itself and set its Format property to mmm if you want the abbreviated name such as Jan, Feb etc., or to mmmm for the complete name such as January, February. You can also create a new column based on the date field.

Reply | Quote

Thanks. is it possible to do the formating not in the date field itself but in the report ?

Reply | Quote

Yes: place a text box bound to the date field on the report, and set the Format property of the text box to mmm or mmmm.

Reply | Quote

Thanks. If i put in the Format propert mmm or mmmm or the months are named January. Why is it so ?

Reply | Quote

Sorry, I don’t understand. Did you mean “all” the months are named January?

Reply | Quote

yes, all the months. But the same result is seen also in the totals query if i put xxx in the Format property. .Is it possibl to write Format in the control ?

Reply | Quote

What is the field you are trying this on? It should NOT be a field defined as Month([InvoiceDate]) or something like that, but the date field itself.

You could try

Format([InvoiceDate], “mmm”)

in the query, or

=Format([InvoiceDate], “mmm”)

on the report.

Reply | Quote