I am NOT well versed in databases and for sure not SQL or VBA so if responding please keep it basic and dummy proof. Thanks
I am trying to run a query to find only the [EmpID] shows up more than 3 times, I built a Find Duplicates query using the query Wizard (below is the SQL view of it) and it is not consistent and still shows some employees that only show up once.
Code:
SELECT [tble_Administrative Actions].Date, [tble_Administrative Actions].FirstName, [tble_Administrative Actions].LastName, [tble_Administrative Actions].Category, [tble_Administrative Actions].Offense, [tble_Administrative Actions].EmpID
FROM [tble_Administrative Actions] INNER JOIN [HR Report Employee Master] ON [tble_Administrative Actions].EmpID = [HR Report Employee Master].EmployeeNumber
WHERE ((([tble_Administrative Actions].Date)>=Now()-90) AND (([tble_Administrative Actions].EmpID) In (SELECT [EmpID] FROM [tble_Administrative Actions] As Tmp GROUP BY [EmpID] HAVING Count(*)>3 )) AND (([HR Report Employee Master].CurrentStatusDescription)="active"))
ORDER BY [tble_Administrative Actions].EmpID;