Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
3 years ago

Find max practice per employee

Hello,

I have one table that includes Employee, Date, Location, etc.  This table links to a Location table on Location ID.  In the Location table is a field called practice.  I need to find the for each employee, the practice they have the most locations for.  For example, provider Smith goes to 10 locations, 6 belong to Practice A, 3 to Practice B and 1 to Practice C.  I need to show Smith, Practice A.