Excel
(1)
Database
(1)
DougSteele
(1)

ACCESS Combining fields

Asked By MJR
12-Nov-09 01:34 PM
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 am lost.

it is possible, but most people would consider it a bad idea.

Douglas J. Steele replied to MJR
13-Nov-09 05:48 PM
it is 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 are trying to do, someone can offer a
solution.

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