Find duplicates, concatenate cells

[Sonny Thai]

Hello all,

I have a database where I need to find duplicate rows based on one cell and concatenate the two cells from both into one record. For example i'll have:

ID             NameOne               IDNumber
 
1              John                        2983
 
2              Jones                      2983
 
3              James                     2984
 

I'm wondering if there is a SQL statement where I can search for the duplicates of "2983" and come out with a record of:

ID             NameOne               IDNumber
 
1              John Jones              2983
 
2              James                     2984
 

I've tried loading this into a Datatable and searching through it, but I get out of bounds errors when I try to jump ahead in the search for the next IDNumber to match with the current one. So i'm resorting to an SQL statement (which by searching the net I figure its possible) Thanks in advance!

[ck9663]

Here, tweak this

Happy Coding!!!

~~ CK