Financial (Fiscal) Year Field

[pauldog]

I have created a query in Access 2000 which contains a date field in short date format.

I would like to add a field to this query which calculates the financial (fiscal) year from my date field. Our financial year runs from Apr 1st to Mar 31st.

I'm totally stuck - any ideas would be greatly appreciated!!

 

[mhartman]

Here you go:

http://support.microsoft.com/kb/210249/en-us

Regards

 

[pauldog]

Excellent - many thanks!

 

[mhartman]

Hello: Your welcome and good luck with this.