Move from calendar year to fiscal year in future reports

[jmac1981]

Hello all,



I recently started a new job, where I have taken control of an Access 2010 database and application. This system pulls data from an Oracle system we have and imports it into an Access 2010 database and app that allows management to run reports on various accounting matters. One of the things they want me to do is change the forms for 2016 to display the fiscal year, not the calendar year. For example, up until now all reports start with January and end in December. Starting for this new fiscal year (October 2015 - September 2016) they want the reports to start in October and end next September.

Im just wondering if there are any simple ways to go about doing this, or am I going to have to go through each and every form and report and manually change things? Any insights or help you guys can offer would be greatly appreciated. My background is mostly as an Oracle DBA, but I catch on quick. I do have a lot of experience with Access and VBA, but that was in the 2003 - 2005 timeframe.

Thanks!

[ItsMe]

The VBA you used in 2003 - 2005 should still apply today. You will have to look at the Report's recordsource and adjust it accordingly
.