Crosstab Fiscal Year on Year Query

[DJF]

I have created a query in my database which shows year on year data by calendar year. However, I want to show it by fiscal year (running from 1 June to 31 May). So, for example, instead of 2014, 15, 16 etc, it will be 2014-15, 2015-16, 2016-17, 2017-18 and so on. Can someone please tell me how to do this? Below is how the query returns data (I have blanked out some personal information).





Currently the SQL is written as:

TRANSFORM Sum(FINANCIALS.Net) AS SumOfNet
SELECT FINANCIALS.[TYPE OF COST], Sum(FINANCIALS.Net) AS [Total Of Net]
FROM FINANCIALS
GROUP BY FINANCIALS.[TYPE OF COST]
PIVOT Format([Date],"yyyy");

But as a relative newbie to MS Access I am teaching myself as I go and i'm stuck on this.

Hope you can help!!!

[ranman256]

Create a 'report' table. In a form make a year textbox, txtYear, enter 2016.

also have 2 text boxes, txtStartDate, and txtEndDate. These autofill when you enter the year. (using the afterupdate event)
txtStartDate sets to the mm/dd/ & txtYear. Same with txtEndDate.

put a button to run the append query, to pull all data from the main table and post to the report table.
it will have an extra field , FiscalYr, from the query.

continue with as many years as you want.
when done, run the crosstab query against the report table.