Months Out of Order

[OWilson]

Hello,

I have a report based on a query that lists cost code
expenditures by month. I cannot get the months to come
up in order. They appear in alphabetical order, not date
order.

The month field is a text field.

Is there a way to get the months to appear in Date Order?

TIA

Owen

 

[Marshall Barton]

I have a report based on a query that lists cost code
expenditures by month. I cannot get the months to come
up in order. They appear in alphabetical order, not date
order.

The month field is a text field.

Is there a way to get the months to appear in Date Order?

You'll have to convert the month name to a number or date
type to sort it numerically. You could write you own
function to do it or, if you do not have to worry about
local language settings:

=CDate(monthfield & " 1 " & Year(Date()))

but that year calculation may not be right all the time.

 

[Guest]

I am having the same problem in that my query has the date correctly but when
I try to create a report based on the query, the date appears in alpha order.
How do I make my Date by Month header appear in chronological order.

Kate Rogers

 

[PC Datasheet]

You need the following two fields in your query:
MonthName:Format([MyDateField],"mmmm")
MonthNumber:Month([MyDateField])

Sort on MonthNumber but display MonthName in your form or report.