Ordering on reports

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey,

Iv got a report that lists months how can i get it to sort to display
month oder as april, may, june, july, august,sep,oct, nov, dec, jan,
feb, march...

fiona
 
What is your actual field name an value? Your sample values don't show any
consistency so it is impossible to determine if the field contains a real
date, a month number, a 3 character text value, the full text value,...

From what you have, just set the sorting and grouping expression to:
=Instr("april, may, june, july, august,sep,oct, nov, dec, jan, feb, march",
[YourField])
 
Fie,
In the query behind your report, create a calculated field like this...
MonthVal : Month(YourDateFieldName)
Use this bound field (MonthVal) to "sort" the data in the Sorting and
Grouping dialog box of the report.
 
what i have... is basically a Date that the user entered and in the
query behind the report i have a
formula
Month: Format([Weekending],"mmmm") this gives me the month...
I want my report to produces results for a finacial year April 2005 to
March 2006.. but when i run the report is
orders the report in Alphabetical Order April, August, December,
January etc..instead of April, May, June, July etc
 
thanks that works.... but instead of diplaying the month name its
displaying the number..
how do i get the name??

fie
 
Back
Top