Quarters of a year in a Crosstab

[Ian]

I have a crosstab query that displays quarterly results,
but it seems the default quarters in Access are for the
calendar year. Is there any way this can be adjusted,
such as in my case, for the Australian financial year
where the first quarter starts on July 1

Thanks
Ian

 

[Michel Walsh]

HI,


Artificially add (or subtract) 6 months (NOT with an update of the
data, but where the comparison is performed: criteria, or for crosstab, in
the PIVOT) :


TRANSFORM
....
PIVOT Format( DateAdd( "m" , -6, ActualDateAndTime ) , "q" )




Hoping it may help,
Vanderghast, Access MVP

 

[Ian]

Thanks so much, your advice really helped me.

Ian