FROM dbo_Employees INNER JOIN dbo_Warnings ON dbo_Employees.[EmployeeId] = dbo_Warnings.[IssuedFor]
WHERE (((dbo_Warnings.IssuedAt)>Date()-7) AND ((dbo_Warnings.IsPackerWarning)=True))
ORDER BY dbo_Warnings.IssuedAt DESC , dbo_Warnings.IssuedFor, dbo_Warnings.WarningType;
dbo_Warnings.WarningType lists the type of warning a employee can get. Lets say there could be hundreds of different fields as it doesn't matter how many they are, what I need to happen is only show the employee in the report if they have 3 or more of the same kind.
Could I have some advice on which route to take?
I played about with COUNT but could not get a successful formula that would give me the results I am looking for.