Deleting Duplicate Records in a Table

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hi,

I need to be able to delete duplicate records in a table. The problem is
that i would need to run this constantly. I know about the procedure of
creating a new table with the duplicate records table and then using Append
query. The problem with this is that I will always have to delete that table
and recreate the new table in order for the append query to work. I have to
update this database 3 times a day. I need to find an easier way of doing
this.

Thanks
Linda
 
Hi Linda

You seem t be ok with deleting the duplicate you have at the moment.

The only thing I would suggest is that you simply don't allow any more. Use
indexing in the tables to stop duplicates or warning messages on the input
form or even (at a last resort) before update events to simply not allow.
 
Let me explain my db, it is a lookup tool for our employees. So in order for
me to have up to date info in it, I need to run the queries and get the
correct info form several different tables. But the stock codes and
descriptions are the same and the info may change, so I need to update that
table with the most current info but without duplicates. I need to run this
query 3 times a day. Using the append feature does not help because that
means i need to recreate a new table everytime i run the query where as I
would like to up date the table without duplicates and without creating anew
table every time.


Thanks
Linda
 
Does anyone know if this is possible to do?

Linda said:
Let me explain my db, it is a lookup tool for our employees. So in order for
me to have up to date info in it, I need to run the queries and get the
correct info form several different tables. But the stock codes and
descriptions are the same and the info may change, so I need to update that
table with the most current info but without duplicates. I need to run this
query 3 times a day. Using the append feature does not help because that
means i need to recreate a new table everytime i run the query where as I
would like to up date the table without duplicates and without creating anew
table every time.


Thanks
Linda
Click to expand...
 
Back
Top