Hello,
I am sure this is a fairly simple query but I am drawing a blank today. I have a single table of 4500 rows that contains the following fields.
Table Name = RK_BOM
Model_Number
Model_Description
Item_Number
Option_Class
Country
Background on table data: The table contains a list of models from different countries. The models are composed of one or more items to form a kit. The idea is to compare all the items and see how many of the kits contain similar items.
From the info above I am trying to write a query to look at all the Item_Numbers and match them to all the applicable Model_Number(Kits).
Any help would be appreciated.
Thanks,
Mack
I am sure this is a fairly simple query but I am drawing a blank today. I have a single table of 4500 rows that contains the following fields.
Table Name = RK_BOM
Model_Number
Model_Description
Item_Number
Option_Class
Country
Background on table data: The table contains a list of models from different countries. The models are composed of one or more items to form a kit. The idea is to compare all the items and see how many of the kits contain similar items.
From the info above I am trying to write a query to look at all the Item_Numbers and match them to all the applicable Model_Number(Kits).
Any help would be appreciated.
Thanks,
Mack