Search results

Excellent - many thanks!

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...