I am trying to return a Top 3 grouped by other criteria such as salesman. If found this SQL solution, but it does not seem to work.
I’ve been working with a part-time Access programmer at my company and he is stumped right now as well. We thought we had it working last week, but must have been getting a false positive.
SQL and Results: https://imgur.com/a/zcNCubv
Any help greatly appreciated!