finding distinct items

[DG2005]

Hi: would appreciate some help as I'm affraid I'm still just a beginner.

I have three fields:

Part No.

Bin No.

Sub-bin No.

Parts go into bins

this is an existing spreadsheet we inherited from a parts supplier that went out of business.

We want to figure out if a Part No. is assigned to more than one Bin No. and/or more than one Sub-bin No.

There are 1.6 million parts, 58 Bins, 1142 Sub-bins. all irrelevant...but you get the idea of what we're trying to do.

bins and sub-bins are numeric and part numbers are alpha numeric.

Thanks!!

Doc

Edited April 21, 2009 by Guest
added subject

[Phillip Holmes]

Hi,

One way is to create a new DB with 2 table that hold info from your current inventory table and the other (table 2) holds the EXCEL info.

Create a relationship between the 2 table using PART NO and then from table 2 (The Excel table) create a LIST layout that has both tables on it in LIST form and you will see what parts are in what BINS from the perspective of the EXCEL file.

Edited April 21, 2009 by Guest