Fiscal Year Query

[Fiona H]

So, I was wondering if I am making this too difficult...

I have a linked table and I am making a new table based on this which has fewer columns. I would also like to reduce the number of rows by only including data from the current financial (Fiscal in America?) year and the last two financial years. (So currently 2013/14, 2014/15 and 2015/16)

It there an easy way to write this as code so that it doesn't need to be updated in a years time and will automatically move on to select 2014/15, 2015/16 2016/17? :banghead:

Thanks
Fee

 

[jdraw]

Have you considered using a query to select only the data you want when you want?
Can you tell us more about your proposed application?

 

[Fiona H]

Thanks for replying, I have tried using a query, it isn't going well!

I need to be able to select data from the current year and the preceding two years and use that to create a new table. I can to do this if I use the actual year, but I can't make it work using fiscal years...

 

[jdraw]

Show us what you have tried --query sql.
Here's an article I found via google that may be helpful.
http://support.microsoft.com/en-us/kb/210249

 

[Fiona H]

With a little help from a friend...

>="1/4/" & IIf((Month(Now()))>3,(Year(Now())-2),(Year(Now())-3))