AnsweredAssumed Answered

Merging/Combining Issue

Question asked by TimSchweitzer on Oct 11, 2011
Latest reply on Oct 11, 2011 by philmodjunk


Merging/Combining Issue


I'm working to solve an issue with my first database.  It's essentially a collection of information about where people have been seen.  Like this:

The fields are FirstName, LastName, and SiteSeen. so the info looks like this.

Michael  Scott   New Jersey

John      Doe     London

John      Doe     Australia


Now, basically what I want to do is reduce records that have the same name into one record per person and combining the location field, so that the resulting record would look like this:

Michael  Scott   New Jersey

John      Doe    London, Australia


Or something of that sort.  Is there a way to do this without manually going through and checking for matches with each name?  Thanks for any help you can provide.