CODE
SELECT Count([Q&R Task List].[Line No]) AS [CountOfLine No], [Q&R Task List].Current, Format([scheduled verification finish],"mm/yy") AS [year], [Q&R Task List].[Scheduled Verification Finish], Format(DateAdd("m",2,Date()),"mm/yy") AS Expr1
FROM [Q&R Task List]
GROUP BY [Q&R Task List].Current, Format([scheduled verification finish],"mm/yy"), [Q&R Task List].[Scheduled Verification Finish], Format(DateAdd("m",2,Date()),"mm/yy")
HAVING ((([Q&R Task List].Current)=True) AND ((Format([scheduled verification finish],"mm/yy"))>Format(DateAdd("m",2,Date()),"mm/yy")) AND (([Q&R Task List].[Scheduled Verification Finish]) Like "#*#"));
FROM [Q&R Task List]
GROUP BY [Q&R Task List].Current, Format([scheduled verification finish],"mm/yy"), [Q&R Task List].[Scheduled Verification Finish], Format(DateAdd("m",2,Date()),"mm/yy")
HAVING ((([Q&R Task List].Current)=True) AND ((Format([scheduled verification finish],"mm/yy"))>Format(DateAdd("m",2,Date()),"mm/yy")) AND (([Q&R Task List].[Scheduled Verification Finish]) Like "#*#"));
^^^ Is the sql to my query so far. However it still picks up dates that fall in the next three months. Could anyone shed any light on how I might coax it into working? BTW the 'Line No' is my PK and 'Current' is checked in order to only select the current records.