Financial year sorting

[Postman]

At present I have the report through the standard report wizard sorted by
year then sub-sorted by month. The Query that my report is based on is for
records spanning 4 years +.

I want to be able to sort order the records from July 1st 19## to June 30th
20##.
Basicly sort the records for a financial taxation purposes in the one
report.

Thaks in advance.

 

[John Spencer (MVP)]

I think that you want to group on Financial Years which rumn from July 1 to June 30th.

You can calculate the financial year using a bit of date arithmetic.

Field: FY: YEAR(DateAdd("m",6,[YourDateField]))

What this does is to subtract 6 months from any date and then get the year of
that result.

so July 1, 1999 becomes Jan 1, 2000 and the year is 2000
May 28,2000 becomes Nov 28, 2000 and the year is 2000

If you number your FY the other direction change the 6 to -6