Combine rows in a table

[Jackxxx]

I have a table that has many rows, but some of the rows have a husband and wife in separate rows, they are at the same address. So the lastname is the same the first name is different and the address is the same for these types of rows.
I need to do a make table that moves all last names, combines the two first names (like Jim and Sandy), and moves the address.

So I'm trying to end-up with a single row for these types of records.

Any suggestions is greatly appreciated.

 

[dhookom]

faq701-4233

Duane
Hook'D on Access
MS Access MVP