Entering month only in a report

[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.

 

[burrcm]

Hide your date field and reference it with this =MonthName(Month([your fieldname]),3)

Chris B

 

[burrcm]

Or to be more specific, set your fields visible property to no, create a new unbound textbox in the same section of the report and set its control source to the above. You can move it over the hidden control so it appears on the report in the same place. Run the report and you should see the month only.

Chris B