Hi,
I have a query where I need to pull data for the same dates entered within a parameter but for the previous year.
For example: The parameter asks for a Start Date and End Date. I would enter 06/01/2005 and 06/03/2005 respectively. I want the following query to return the data within the table between 06/01/2004 and 06/03/2004.
Between Year([Reports]![Carrier By Month]![Text41])-1 And Year([Reports]![Carrier By Month]![Text43])-1
Currently what this criteria is doing is pulling the data for the previous year as I need but it is returning everything for 2004 that exists within the table. For example I have stuff for 05/01/2004 and it returns this data. I only need it to return the previous year data within the date range I entered within the parameter.
Any help on this would be greatly appreciated. I have been bursting my brain on this.