delete duplicates

[trythis]

I have a table that is appended with new data once a week. There was a problem with that and for several weeks the data was added more than once.

Now I have 2, 3 and 4 entries that are exactly the same and I need to delete all but one.

Can I export and remove duplicates or append to another table and remove duplicates????????

Help!!!

Tina

 

[Brianwarnock]

If the duplication is recognised by the data in one field then create a newtable of the same structure but set the properties of that field to no duplicates and then yes run an append query from the first table to the new table.

Brian

 

[trythis]

If the duplication is recognised by the data in one field then create a newtable of the same structure but set the properties of that field to no duplicates and then yes run an append query from the first table to the new table.

Brian

The duplicates are spread over several fields. The start date and time and the name will be the same but the combination will be different.

Example
12/10/2009 15:00 jane doe
12/11/2009 15:00 jane doe

those two are fine they are for a different date
this would be ok
12/10/2009 13:00 jane doe
12/10/2009 16:00 jane doe

as long as something is different it is ok but when those three items are exactly the same that is wrong. So if the whole row is the same I need all but one removed.

Thanks,
Tina

 

[Galaxiom]

Use SELECT DISTINCT in the append query.
http://office.microsoft.com/en-au/access/HA012313511033.aspx