ACCESS Combining fields

[MJR]

I have exported data to a Excel XLS file then I import it into access. The
fields look like this:

Host_N IP Address Interface - Name
OS Name
Server_03 192.168.1.110 Server_03.sx.company.com
MS W2K3 R2
Server_03 192.168.1.123 Server_03-rib.sx.company.com
MS W2K3 R2
Server_04 192.168.1.103 Server_04.sx.company.com
MS W2K3 R2
Server_04 192.168.1.126 Server_04-rib.sx.company.com
MS W2K3 R2
Server_04 192.168.1.105 portal.web.company.com
MS W2K3 R2
Server_04 192.168.1.64 mysites.web.company.com
MS W2K3 R2

I.E. Server_04 lists 4 ip addresses, 4 Interface names

Is there a way to create 1 record for server_04 and combine the 4 ip
addresses into 1 field (or combo box or other) and the multiple interface
names?

I'm lost.

[Douglas J. Steele]

It's possible, but most people would consider it a bad idea.

You're using a relational database. Use it relationally! Each field should
contain one, and only one, piece of information.

Perhaps if you can explain what you're trying to do, someone can offer a
solution.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"MJR" <hairli...@yahoo.com> wrote in message
news:D7C99DCC-C03D-4DA9...@microsoft.com...