Cross tab for a fiscal year starting in Oct

[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?

 

[Michel Walsh]

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

 

[KARL DEWEY]

I do believe it will be +3 and not -9 for FY in October.

 

[Michel Walsh]

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