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.

 

[RuralGuy]

You get the sort order by sorting on the raw date field. You can get the display you want by setting the ControlSource of the control on the report to:
=MonthName(Month([YourDateField]),True)

 

[boblarson]

You get the sort order by sorting on the raw date field. You can get the display you want by setting the ControlSource of the control on the report to:
=MonthName(Month([YourDateField]),True)

Wouldn't that get the whole name? I would think Formatting would work here by just putting

=Format([YourDateField],"mmm")

 

[RuralGuy]

Both approaches work Bob.

 

[capsula4]

Wouldn't that get the whole name? I would think Formatting would work here by just putting

=Format([YourDateField],"mmm")

Actually the value True for MonthDate enables abreviated months, so he will see only the first 3 letters by typing true, so this should work:

=MonthName(Month([YourDateField]),True)

 

[Chum]

Entering Month name in a report NEW

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.

 

[boblarson]

Both approaches work Bob.

That's why I asked

 

[RuralGuy]

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.

Have you looked at [YourDateField] in the query to see what is being returned? Do you have some Null fields?