Quarters of a year in a Crosstab

  • Thread starter Thread starter Ian
  • Start date Start date
I

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
 
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
 
Back
Top