I can not figure out how to fix the problem I have with the access database. If anyone could help it would be greatly appreciated. Here is my macro I use for the parameters and I am also going to include the 2 queries I use to produce the form. I will also give the SQL to produce the form. Thanks
stLinkCriteria = "([CalExpires]>Now()) And ([Tester_Info.TNRCC_Reg_Date]>Now())"
stLabel = "Current Backflow Tester Information"
SELECT Tester_Info.TesterID, ([LastName] & ", " & [FirstName]) AS Tester, Tester_Info.TNRCC_Reg_Date AS State, Calibration_Dates.Calibration_Date, ([Calibration_Dates]![Calibration_Date]+365) AS [Good Until]
FROM Tester_Info INNER JOIN Calibration_Dates ON Tester_Info.TesterID = Calibration_Dates.TesterID
WHERE (((Tester_Info.TNRCC_Reg_Date)>=Now()) AND ((Calibration_Dates.Calibration_Date)<=Now()) AND ((([Calibration_Dates]![Calibration_Date]+365))>=Now()))
ORDER BY ([LastName] & ", " & [FirstName]);
SELECT Todays_Qualified_Testers_Sub1_qry.TesterID, Max(Todays_Qualified_Testers_Sub1_qry.Calibration_ Date) AS [Date]
GROUP BY Todays_Qualified_Testers_Sub1_qry.TesterID;
SELECT Tester_Info.*, Todays_Qualified_Testers_Sub2_qry.TesterID AS T FROM Tester_Info LEFT JOIN Todays_Qualified_Testers_Sub2_qry ON Tester_Info.TesterID = Todays_Qualified_Testers_Sub2_qry.TesterID;