Need to define the start of year as November

[swaykid]

Does anyone know a function that can do this?.

Accountants insist on defining the start of the year at random points, and for my report need to analyse sales figure from start of november to end of october

Any takers?

 

[PaulBricker]

In a new column of your query put something like this
MyFY:IIf(Month([DateField]>=11,"FY" & Year([DateField])+1,"FY" & Year([DateField])

Then you just need to group on this field to have your records fall into the appropriate FY.

Paul

 

[PaulBricker]

Sorry, forgot the closing ) in the IIf statement
MyFY:IIf(Month([DateField]>=11,"FY" & Year([DateField])+1,"FY" & Year([DateField]))

Paul

 

[swaykid]

Thanks Paul.