>I feel like I've done this before but for the life of me I can't remember how I did it:
>
>Using just SQL Select how can I get the items with the Max count.
>

>Source table
>
>ColumnCode1  ColumnCode2  ColumnCode3   CodeCount
>Code1          Code2         code3         3
>Code1          Code2         Code4         2
>

>
>What I'm trying to get to is for each identical ColumnCode1, ColumnCode2 I want to see only the ColumnCode3 with the most CodeCount.
>
>Something like this:
>

>ColumnCode1  ColumnCode2  ColumnCode3
>Code1          Code2         code3
>

>
>Any ideas?
>
>Richard

SELECT MyTable.ColumnCode1,MyTable.ColumnCode2, MyTable.ColumnCode3, MyTable.CodeCount;
FROM MyTable;
INNER JOIN (SELECT ColumnCode1,ColumnCode2, MAX(CodeCount) AS CodeCount FROM MyTable GROUP BY ColumnCode1,ColumnCode2) Tbl1;
      ON MyTable.ColumnCode1 = Tbl1.ColumnCode1 AND;
         MyTable.ColumnCode2 = Tbl1.ColumnCode2 AND;
         MyTable.CodeCount   = Tbl1.CodeCount;
INTO CURSOR crsTest
BROW NORMAL

(not tested)