Bob, not to put a bee in you bonnet... But what will happen if today is December 5???
In your setting you will get a static value for the months of October, november and December....
Instead I find it 'easier' to shift the 'financial year' to a 'proper year' using:
Dateadd("M",3,date())
I tried this code, but I am getting a syntax error.
=DSum("Traffic", "tbl_Tickets", "Year(Dateadd("M",3,date())) = Year(Dateadd("M",3,nz([Ticket_Date],Date())))
Syntax error simply means there is something wrong with the literal syntax.....
I am pretty sure if you spend 2 seconds really looking (a little) hard(er) you can find the error...
If you 'space' the code to match the brackets like so:
No you do not, basicaly you want to change Oct 1 to Jan 1 and change Sep 30 to Dec 30
As a result the "financial Year" will be the same, throughout the year....