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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Current fiscal year 8
Query current fiscal year 2
Fiscal year 3
Calculating fiscal year for two dates in query 5
select dates for last fiscal year 3
select fiscal year on a query 1
New column to get fiscal year from existing dates 8
Tracking annual training when my fiscal year starts October 1st 3

Back
Top