duplicates

[Jim]

I'm importing data into a database with Location, Date, and Number. When
it's imported, there are multiple dates with the same location and number,
and there should be. Unfortunately, I only need one copy of that info. Is
there a way to sort through automatically and erase all but one of the dates
with the same location and number?

 

[Jeff Boyce]

Jim

Consider creating a query and setting the UniqueValues property to Yes.
This should return one copy of each unique combination.