Posted by Yas on 08/07/07 10:05

On 26 Jul, 18:23, Roy Harvey <roy_har...@snet.net> wrote:
> Try this.
>
> SELECT TOP 1 WITH TIES
> homeMDB, count(*) as UserAccounts
> FROM tblADusers
> WHERE Left(homeMDB,13) = 'CN=MYSEREX306'
> GROUP BY homeMDB
> ORDER BY count(*)
>
> Roy Harvey
> Beacon Falls, CT
>

Thank You! that worked really well.

[Back to original message]