Help with ms access queries

[alstar]

Hi Guys,

This is the first time after school that I am trying to use ms access at work and i need ur help in creating a query.
Any help will be highly appreciated!!

Here is what I need...

I have relatively small ms acces database with about 1000

I have 3 colums

date ipaddress sitename

12/09 34.3.3.3 A
12/09 34.3.3.3 A
12/09 34.3.3.3 A
12/09 33.4.4.4 B
12/09 33.4.4.55 C


What i need is if an ipadress is recorded more than 2 times in a single month for instance (34.3.3.3) put those ipaddress with the Site-Name in a seperate table.

Any ideas?

 

[Rich]

What would be the logic for having another table simply because a record appears more than once? p.s. There's a rat in separate by the way

 

[alstar]

Yeah that the purpose actually, if a IP is recorded mutiple times in a single month put that in a separate tabel as u mentioned.

Let me tell you why, this is actually a virus alert database that I have which records alerts from computers if they are infected with a virus, so that is the reason I want ipaddresses which are recorded multiple times in a single month to be seperated so that I can contact the Site and inform them about it.

 

[Rich]

Since you would have to use a query to determine which records to append to the second table you may as well just use that query to view those records and take the appropriate action from there