Cross tab for a fiscal year starting in Oct

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I am having to change all cross tab report from calendar year to fiscal year
which begins in October. Any sugestions on how to accomplish this?
 
You can PIVOT on expression. Instead of:


TRANSFORM ...
PIVOT YEAR(yourDateFieldName)


you can try:

TRANSFORM ...
PIVOT YEAR( DateAdd("m", -9, yourDateFieldName) )


Doing so, October 2006 to (included) September 2007 should appear under
year 2006.


Hoping it may help,
Vanderghast, Access MVP
 
That will work too, but doing so, October 2006 to (included) September 2007
would appear under year 2007 instead of 2006. Depends on how you call that
fiscal year, after all :-)


Vanderghast, Access MVP
 
Back
Top