Query tables using date criteria
Posted on 2012-08-27
I have googled this already but couldn't find an answer that exactly fitted this so...
I want to create a query on my Access database which will tell me at a glance how my turnover matched up to the corresponding date last year, and the year before that, and so on.
I have 7 tables so far, which contain the data I am trying to look at. So let's say that the tables are 2006,2007,2008, etc and each of the tables has a field named InvoiceAmount and a field named InvoiceDate.
Obviously I can easily see a running total of my invoice amounts for this year, but I want to be able to compare this figure with the same date last year, and the year before, and the year before that.....
I don't know how to configure the criteria in the query to tell me the figure on the same date in a different year, and since this will change every day it needs to be a variable query.
I look forward to receiving your coments on this
I forgot to mention this is Access 2010, my knowledge is limited, not a beginner but by no means an expert!