Importing records then deleting redundant records

[Jarvis]

I have a database that tracks customer support phone calls.

This database has three fields:

CALLER NAME

TELEPHONE NUMBER

MESSAGE

Sometimes I receive messages from a caller just once.

Other times I will receive several messages from the same caller.

I would like to produce a phone directory of unique records.

Is there a way of importing the records from the first database into a second database that will

delete any duplicate (redundant) occurrences?

I want have the customer's name and number just show up once, regardless of how many times they have called. (I would also like to have a count of how many times they have called on the other database, but that is a question for another thread.)

I hope I explained this right.

Thanks for any help.

Jarvis

[dkemme]

Actually, the count function is just what you need. Make a self join of this table from caller name to caller name. Then create a calculated field, number, that is count ( selfJoin::Caller Name ). You can create script that would find and record that had more than one of the calculated field, delete the duplicates, and you have just what you need. Count will also tell you how many times that caller called.

[Jarvis]

Doug,

That was a very clear answer.

Very easy to understand.

Thank you!

Jarvis