Grouping

[Fie]

Hey,


I have a repot which i want to sort in financial year (april, may,
june, july, aug, sep, oct,nov, dec, jan, feb, march) order how do u do
this, cause if you go into ordering and grouping and select month and
assending it buts it in alphabetial order.


fie

 

[Duane Hookom]

Do you have a date field? I would think that you could subtract 3 months or
1 quarter from the date field to get the financial year.

FiscalYrMth: Format(DateAdd("m", -3, [YourDateField]),"yyyymm")

 

[John Spencer]

Wow. You like to make it tough. The only thing we know about your report
is that it has a month name in it. The following should work to put things
in order by month. Where April is month one of the Fiscal year.

= Month(DateAdd("m",-3,CDate([MonthField] & " 1," & " 2002")))