Well, I wasn't planning on making this a seminar, but at least three different customers asked me about this over the past two weeks, and one of them really needed to learn how to do it, and he submitted it as a PAID TechHelp question. So... I decided to turn it into a short seminar.
This Fiscal Year Seminar will teach you how to perform calculations in your Access databases based on a company's fiscal year. You will...
1. Learn how to calculate a simple fiscal year (starting 6/1, for example)
2. Create sales totals with an aggregate query or report grouping
3. Calculate fiscal year not based on the 1st of a month
4. Determine fiscal year for multiple companies in the same database
You can watch the free introductory and review lessons, and learn more about this seminar here: Microsoft Access Fiscal Year Seminar