
March 7th, 2013, 04:32 PM
|
|
Registered User
|
|
Join Date: Jul 2011
Posts: 4
Time spent in forums: 1 h 13 sec
Reputation Power: 0
|
|
|
Query Help - Multiple Values Count and Show Once
I have a scenario, where client can have more than one Race like below
ClientId Client Name Client Datebirth Client Race
100 John, Smith 01/01/1980 White
100 John, Smith 01/01/1980 AmericanIndian
101 John, Dose 03/01/1977 Black
102 Doe, John 01/23/1983 Asian
102 Doe, John 01/23/1983 White
I would like to know how to show the client in only one group, for example if client got counted in White then i dont want him to again appear under american indian
White
100 John, Smith 01/01/1980
102 Doe, John 01/23/1983
Count: 2
Black
101 John, Dose 03/01/1977 Black
Count: 1
AmericanIndian
Count: 0
Asian
Count: 0
Appreciate your guidance and feedback
Thanks
|