duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Jim

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