Help with creating a field
I could have 40 records in a particular database. Each of those records would have a name field and a number field. It is possible that a record's number field could be totally unique, for instance, it could have only a "1" in it's field. But it is also possible that 2, 3, 4 or more records could have the number field contain the number "1". The number field could also be a number and a letter ( 1A ). I need another field, then, that would consider the number fields of the individual records, and if they are the same, combine those records (names) into one name field.
In other words, if:
Record1 = (Name) John (Number) = 1
Record 2 = (Name) Jeff (Number) = 1
Record 3 = (Name) James (Number) = 1
Record 4 = (Name) Fred (Number) = 1 then, there would be a field that combined the names John, Jeff, James, Fred.
Record 5 = (Name) Jack (Number) = 2 then, the field would have only the name Jack in it.
Record 6 = (Name) Harold (Number) = 2A
Record 7 = (Name) Jason (Number) = 2A
Record 8 = (Name) Taylor (Number) = 2A
Record 9 = (Name) Chris (Number) = 2A then, there would be a field that combined the names Harold, Jason, Taylor, Chris
If someone could help me figure this out, I would appreciate it.