That did the trick. Thanks,

Richard


>>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)