I'd like to set up a form to generate a report base on a selection in a combo box.
The combo box needs to auto populate with the last 4 financial years plus current.
Example:
2006/07
2007/08
2008/09
2009/10
2010/11
But I need the report to pick up the full start and end dates like this:
1/7/2006 – 30/6/2007
1/7/2007 – 30/6/2008
1/7/2008 – 30/6/2009
1/7/2009 – 30/6/2010
1/7/2010 – 30/6/2011
Appreciate any help