Ordering on reports

[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

 

[Duane Hookom]

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])

 

[Al Camp]

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.

 

[Fie]

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

 

[Duane Hookom]

Add a field to your query
SortMthNum: Month(DateAdd("m", -3,[Weekending]))

 

[Fie]

thanks that works.... but instead of diplaying the month name its
displaying the number..
how do i get the name??

fie

 

[Fie]

tis okaly... iv got it to work...

thanks for your help...

fie