Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
225
Group by ID but Show Client Name
posted

If you have a database that has an ID field and a Client_Name field, how can you group by the ID row yet show the Client Name for the group name.

Sally Smith - ID 1

Sally Smith  - ID 2

John Smith - ID 3

I should see three groups basically when I'm done even though Sally Smith is duplicated in name.