General discussion


Using MS Access 2000 or 2003

By kgamzon ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Lord Foul In reply to Using MS Access 2000 or 2 ...

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.


Related Discussions

Related Forums