Search results

I need help with a query. CLEAN_SS (table name) [ID] [CompName] [EmpSS] [EmpLast] [EmpFirst] [Type] [Reason] [Date] I need help designing a query from this table that will show me the highest (MAX) [Type] based on the [Date] field for Each [EmpSS] with each [CompName]. So if WALMART...