keeping table values unique

[scrappe7]

hello all i am sure this is a simple question. i have a table that gets its data impported daily. as a result some of the data is often repeated. i have a query that finds all unique values within that table. i would like to take the results of my query and use them to create a cleaner tbale. i would run the query. delete the old table. then copy the query data to a table that had the same name as the one i just deleted. all i want to do is cleanse to keep the file size down. is this possible?

Ed

 

[gol4]

Yes if I understand what it is you are doing. See make table querys under access help.
Another option to consider is to have the imports placed in another table then only append records that aren't dupes.

 

[thornmastr]

Why not make the field that seems to have duplicates defined to be unique on your database. That way, duplicate records will not update. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com