select VNUmber, FullName, count(ShipTo) from tCustomer --# where VNumber = "10000285" --# and Shipto = "CWT" group by VNumber, FullName having count(ShipTo) > 1 order by 1