Make two records one

[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

 

[Dave]

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