How to get rid of repeat data...HELP!

[ljjtek]

Thanks to all the help I've gotten from everyone on here, I've managed to import the data that I wanted into a database....now here's my next question....I've imported weblog data that has, for each time a person visits my website, the various data like time, data, referer, etc.... Now I would like to have every IP address show only once, as in making it a primary key, and then have the rest of the data be in another table, joined by a relationship.... I couldn't do this when I orginally imported the data because when I check the no duplicates option, obviously it can't do that without skipping a great deal of the records. I'm not sure if a query could do this or if I'm just SOL...So any ideas would be great!

 

[GingerR]

create a Make-Table query, GROUP BY the IP address, and have the IP address be the only resulting field.

once that table is made, go into its design and make the IP Address field the PRIMARY KEY.

then go into the RELATIONSHIPS window, and create a relationship between the IPAddress fields of the two tables.

 

[ljjtek]

Thank you thank you thank you!!