Either way, I don't think I can put that into a join.

Thanks,

-Michelle

>You have the option of TOP N (ccurrences)or TOP N PERCENT.
>
>>Maybe I'm misunderstanding that... I thought that was to return the top n% of the matches. I need it to return every client.
>>
>>Thanks,
>>
>>-Michelle
>>
>>>Hi Michelle,
>>>
>>>I'd say you can use the Top clause that exists now in the Select SQL statement.
>>>
>>>Kind regards,
>>>
>>>Marc