Software

Ask something
Discussion Locked

Using MS Access 2000 or 2003

0 helpful
1 reply

by kgamzon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I separate a large database that has multiple contacts with the same phone number to create as many new databases as necessary so that none of them have the same phone number more than once? Can this be done so that I don't eliminate any of the contacts?

1 reply

by lord foul

How about a 'make table' query that takes the phone numbers you specify in the criteria section and puts the other fields you require into this new table(s).
You can place the tables in the same or another database.

Cheers...

This discussion is closed to new replies.