I am working on an access db that is used to compare call volume for current year and previous year. I would like to enter the current year's dates on a from and write a query that will pull the previous year's data based on the dates entered. When using a Date -365 expression, the query shows last year's date however the data pulled is the current years data. Any suggesstions on how to get last years date along with last years data?
April 27, 2010 2:17 PM
April 27, 2010 3:55 PM