Thank you for the quick reply - Am I adding that into the criteria for the same Field and Table, if so it does not work - I have attached the SQL so you have an idea of the entire query:
SELECT IMCDate([AssignDate]) AS [Date], PersonnelFileInfo.LastName, PersonnelFileInfo.Rank, OfficerAttendance.StartTime, OfficerAttendance.EndTime
FROM OfficerAttendance INNER JOIN PersonnelFileInfo ON OfficerAttendance.ID = PersonnelFileInfo.ID
GROUP BY IMCDate([AssignDate]), PersonnelFileInfo.LastName, PersonnelFileInfo.Rank, OfficerAttendance.StartTime, OfficerAttendance.EndTime, IMCDate([AssignDate]), OfficerAttendance.Division, OfficerAttendance.DutyCode
HAVING (((PersonnelFileInfo.Rank)="Sergeant") AND ((IMCDate([AssignDate])) Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)) AND ((OfficerAttendance.Division)="HI") AND ((OfficerAttendance.DutyCode)="OI"))
ORDER BY PersonnelFileInfo.LastName;