Recent content by mack5511

  1. M

    Simple query but I am drawing a blank today.

    Penhall, After some sleep and a discussion with some others it was not as simple as I had thought. I needed to compare every kits contents against every other kit in the list and then cross reference the parts to give a display of one kits contents and the list of other kits in common. Lucky...
  2. M

    Simple query but I am drawing a blank today.

    Penhall, From my thinking the only item numbers that would appear more than once would mean they are part of multiple models.So if that was the case I could eliminate the single items from the list and that would leave only a subset of the models that have items in common. Then a group by...
  3. M

    Simple query but I am drawing a blank today.

    Penhall, The data structure is like the second example you have. So my data looks like this. Model_1, Model Description_1, Item_Number_1, Country_1 Model_1, Model Description_1, Item_Number_2, Country_1 Model_1, Model Description_1, Item_Number_3, Country_1 Model_1, Model Description_1...
  4. M

    Simple query but I am drawing a blank today.

    Penhall, It may be my attempt at explaining is off. That query errors out as Item_Number is not part of the group by clause. I will try to give a better explanation. The Item_number field contains the global items list for all countries models of kits. The person who is requesting this...
  5. M

    Simple query but I am drawing a blank today.

    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...
Back
Top