I have a query that finds duplicate [SerialNumber] and gives all the information for each record. I have been trying to limit the results so if there is more than 7 days between [TestedDate] of each record it will be omitted from the results. Could someone help me with this. Here is the current SQL for the query.
Code:
SELECT qry_duplicates343sTested_Step1.SerialNumber, qry_duplicates343sTested_Step1.FixturePosition, qry_duplicates343sTested_Step1.TankTestedIn, qry_duplicates343sTested_Step1.LoadTested, qry_duplicates343sTested_Step1.TestedDate
FROM qry_duplicates343sTested_Step1
GROUP BY qry_duplicates343sTested_Step1.SerialNumber, qry_duplicates343sTested_Step1.FixturePosition, qry_duplicates343sTested_Step1.TankTestedIn, qry_duplicates343sTested_Step1.LoadTested, qry_duplicates343sTested_Step1.TestedDate;
Thank you in advance
Walker