Huge file with duplicate entrys for multi applications

[Guest]

I have a huge catalog file that has duplicate entrys for a specific
application. I can use no duplicate because the same part number is used in
other applications. Can someone help me out.

 

[Guest]

Assuming your question is related to Microsoft Access, the subject of this
newsgroup, you can use a Find Duplicates query. There is a query wizard
available to guide you through the steps. Click on the Query tab in the
database window. Then click on the New button. You should see the option to
fire off the Find Duplicates wizard, if you did a full installation of Access.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

On Wed, 25 Oct 2006 17:45:01 -0700, catalog trouble <catalog

I have a huge catalog file that has duplicate entrys for a specific
application. I can use no duplicate because the same part number is used in
other applications. Can someone help me out.

Not unless we know what you're trying to accomplish, no.

You have duplicate entries for... what? part numbers?

If you have multiple records for each part number, what do you want to
do? Delete all but one? Which one do you want to keep?


John W. Vinson[MVP]