Fiscal Year in Access 2007

[blindhawkeye]

There are a lot of resources for older version of access and making a field with a Fiscal Year, I have tried them and they do not work in 2007.



So I a field for "Date of Service" which is what we base the fiscal year off of. And I want to populate a field "FY" with either FY10, FY11 or FY12. Our FY10 runs from 10/01/2009 to 09/30/2009. FY11 runs from 10/01/2010 to 09/30/2011. FY12 runs from 10/01/2011 to 09/30/2012.

I also then want it populate another field "Voucher Number" based on the FY# a preditermined text that we use for in office ex:FY11 = f98-33245 FY10 = f98-33548

[RuralGuy]

It looks to me like you just need to take the year of any date plus 9 months to get the FY.