Delete Duplicate Records

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

Guest

My duplicate records really are duplicates. Our Oracle Server is returning
multiple instances of the same record when we query it. (The sys admin
people are working on this <grin>.)

At any rate, what is the best/easiest way to do this? Is one type of query
better than another for performing this search operation? And can you
explain how Access determines whether or not a record is a duplicate of
another record? Thanks.
 
Alice: Your question is worded as though you are continuing a conversation,
but I have no idea what that conversation was. You say, "what's the
best/easiest way to do this?" To do WHAT?

You also say the server is returning multiple instances of the same record.
We'd need to see your query to determine why it is doing that. If it is a
basic select query tied to one table, I can think of almost no way to return
duplicate records. You'd have to have some types of joins to do that.
 
Back
Top