Merging Duplicate Records
I need some help!! I have serached the forum and help database but I must be using the wrong search words.
I have a database that was set-up many years ago. Each time a consumer was issued some special equipment a new record was created. This has resulted in many records for "John Doe" with different serial numbers.
We would like to combine all of John Doe's records into one record with a list of the Serial Numbers in the one record utilizing a "repeating field".
How do I find all of John Doe's records and merge them together keeping some of his information (i.e. address) the same but list the different serial numbers in a repeating field?