Cross tab for a fiscal year starting in Oct

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

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
 
M

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
 
Top