True, maybe I should have read all of the query before posting an answer!!!

>You can, but what if you have this type of data:
>

>ColumnCode1  ColumnCode2  ColumnCode3   CodeCount
>Code1          Code2         code3         3
>Code1          Code2         Code4         2
>Code3          Code1         Code4         12
>Code7          Code9         Code1         21
>

>
>
>
>>Can you use SELECT TOP 1 and then order it by codecount desc?
>>
>>>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