Max of Count Query

[dssrun]

I am trying to find the Maximum value of a count query below. Each employee can see multiple customers and I want to return only the employee who had the highest count per customer. For example, emplyee ID #1, 2, and 3 saw customer #1 10, 20 and 30 times respectively. I only want to return employee ID #3 in my query for that particular customer (so on and so forth). The query below does not work because the Max function returns employees 1,2 and 3 because they have different numbers. Any help is appreciated. Thanks

SELECT aCount.[EmployeeID], Max(aCount.[Panel Size]) AS [Highest]

FROM (SELECT [EmployeeID], tbl1.[CustomerID], Count([CustomerID]) AS [Panel Size]
FROM tbl1
GROUP BY [EmployeeID], CustomerID])  AS aCount

GROUP BY [EmployeeID]

[June7]

Review this http://support.microsoft.com/kb/153747

[dssrun]

I am not sure if this will work (I have tried this solution but i cannot include the "WHERE" in the criteria subquery because i am working with a flat file in access, so I do not have associated tables to lookup in the criteria). Do you have any other suggestions?

[June7]

Works with one table. Review these:

http://allenbrowne.com/subquery-01.html
http://allenbrowne.com/ranking.html

Probably should have pointed you to Allen Browne right off.

[dssrun]

sorry for the late reply, i was side tracked. THanks for the help!