Adding New Data while deleting duplicates

C

Crisyina

I have a table and everyday the table is updated, so the next day i add the
newer table but i need the duplicates deleted so all the infomation will all
be in one table or query. How do I go about doing this?
 
K

Klatuu

Where does the newer table come from?
Do you have a unique field that you use to identify duplicates?
Is it the primary key?
How are you combining the tables now?
 
J

John W. Vinson

I have a table and everyday the table is updated, so the next day i add the
newer table but i need the duplicates deleted so all the infomation will all
be in one table or query. How do I go about doing this?
Click to expand...

I'm sorry, this isn't making sense. You have "a table" that gets updated...
but you're adding "the newer table". One table? One new table every day?
Updating existing records in a table, or adding new records?

Where are the updates coming from, and what is the actual structure of your
tables?
 
Top