Make two records one

  • Thread starter Thread starter rcoulter
  • Start date Start date
R

rcoulter

I have a query with an address, first name, last name. If there are tw
people at this address there are two records. I want one recor
containing address and firstname1, lastname1, firstname2, lastname2

I'm a rookie and stumped
 
The best thing you can do is to create another table
with fields

CustomerKey, FirstName, LastName

then link this table to the main customer table
this way you can have as many people living at an address as you want.

hope this helps
Dave
 
Back
Top