I have this in Fiscal Quarters set up in one of my query. And I have another Crosstab query which will give me the answer to what I want to find.
For example, I wanted to know the amount of money spent in 2009 according to each quarter.
Given that Quarter 1 starts from April to June,
Quarter 2: July to September,
Quarter 3: October to December
and Quarter 4: January to April.
Now my problem is when I run that query for 2009 with respect to its Quarters, it gives me Quarter 4 of the previous year instead.
I wanted Quarter 4 of 2009 (which will be January to April of 2010).
Basically right now, Access took January to December of 2009.
Any idea how I should solve this problem?
What I have right now in one of my query column and under 'Field' is
Quarter: IIf(Month([Visit Date]) In (4,5,6),"1",IIf(Month([Visit Date]) In (7,8,9),"2",IIf(Month([Visit Date]) In (10,11,12),"3","4")))