Months Out of Order

  • Thread starter Thread starter OWilson
  • Start date Start date
O

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
 
OWilson said:
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?
Click to expand...


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.
 
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
 
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.
 
Back
Top