Entering month only in a report, NEW

[Chum]

In a table I used a mask to enter a date, as for example, 1/23/08.

In the report, howerver, I'd like only the name of the month with 3 letters only: Jan, Feb, etc.

In addition I want the months to be in month order, not alphabetized.

Above is the original message I sent.

The responses I received
(1) =MonthName(Month([YourDateField].True) from RuralGuy

(2) =Format([YourDateField],"mmm") from boblarson

both do the job. They don't work if the report comes from a query. Instead I get not the months but #Error.

 

[Rich]

Then post back on the original post

 

[RuralGuy]

Using a query rather than a table should make no difference unless you are not returning the records you expect with the query.