Combining records

[MJ Ross]

I have data exported to an xls then import it to a MS access v7 table that
looks 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

Is there anyway I could create 1 record for the Host_name server then
combine say the multiple ip addresses for that server name into 1 field? Same
would be for Interface name too. I.E.

Server_04 192.168.1.103,192.168.1.126,192.168.1.105,192.168.1.64

I'm stumped.

 

[Tom van Stiphout]

On Thu, 12 Nov 2009 09:24:01 -0800, MJ Ross

Here is one approach:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.
Microsoft Access MVP