Change a default year to financial year in crosstab query.

Change a default year to financial year in crosstab query.

Post by John Simo » Sun, 14 Sep 2003 18:26:43


Hi,

I have date wise failure data for 10 years, I have
prepared a Crosstab query and failures are counted
yearwise from January to December for 10 years. MS Access
by default takes year from January - December. However I
need failures per financial year i.e from April to March
every year.

Thankyou.
 
 
 

Change a default year to financial year in crosstab query.

Post by Allen Brow » Sun, 14 Sep 2003 20:16:46

Group on:
Year(DateAdd("m", -3, [MyDateField])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/