returning the last three completed years data

[gvanhook]

Good afternoon loungers, I am an access noob and trying to figure out the query to return the data I need. My data set contains Fiscal year (FY) as a field. and for some reports I need to look a the last 3 completed fiscal years. I have the following that was inherited with the database will allow me to return just the last completed FY but need assistance in updating this to give me the last three years:

SELECT Actual_Payroll_Data *
FROM Actual_Payroll_Data
INNER JOIN (SELECT MAX(FY)-1 AS MAXFY FROM Actual_Payroll_Data) AS a
ON Actual_Payroll_Data.FY = A.MAXFY;

Thanks for looking,
Greg

[HansV]

Try this:

SELECT Actual_Payroll_Data.*
FROM Actual_Payroll_Data, (SELECT MAX(FY)-1 AS MAXFY FROM Actual_Payroll_Data) AS A
WHERE Actual_Payroll_Data.FY Between A.MAXFY-2 And A.MAXFY;

[gvanhook]

Hans, Worked like a charm. I had tried using the Between line, but I think I actually had it reversed and put the -2 at the end. DOH.

Thanks - Greg