Hi,

With FireBird 2.1.3, I use the select statement displayed below to extract some summary statistics. Our Financial year is from 1 March to end of February. How must I modify the select statement below to extract summary statistics per financial year?

Regards,

Nols Smit

===================================================================
select Categories_Name, Cancelreasons_Name, extract(year from Cancel_Date) as Stats_Year,
count(Cancelreasons_ID) as Count_Reasons, sum(CancelAccount) as SUM_Oustanding
from V_Register_Cancelled
group by Categories_Name, Cancelreasons_Name, Stats_Year