Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Unhappy Unanswered: Simple Query? But I can't figure out how...

    I am stumped and this is probably fairly easy..

    I have one table with a Supplier ID and Name
    Another table is for Parts but lists a 1st, 2nd and 3rd supplier ID for EACH part.

    I want a query/report to show me the Part with the NAME of each 1st, 2nd and 3rd supplier... NOT their ID # as is stored in the table..

    How do I do THIS??

  2. #2
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    u need to link the 2 tables in arelationship
    and drag the name from the first table in the list
    hope this helps

  3. #3
    Join Date
    Nov 2003
    Posts
    300

    please show me

    TABLE ONE - Suppliers

    SUPP ID #
    SUPP NAME

    TABLE TWO - Parts

    PART ID#
    SUPP ID#_1
    SUPP ID#_2
    SUPP ID#_3

    So, how do I get the NAME to print in the query and NOT the Supplier ID?
    Still confused! The query I made gets the following results:

    PART ID SUP 1 SUP 2 SUP 3
    1 4 7 3
    2 7 10 4

    I want this:

    PART ID SUP 1 SUP 2 SUP 3
    1 IBM MS NOVELL
    2 MS ORACLE IBM

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    SELECT PartID, Supplier.Name AS S1Name, Supplier.Name AS S2Name, Supplier.Name AS S3Name FROM ((Parts INNER JOIN Supplier ON Parts.[SUPP ID#_1]=Supplier.SupplierID) INNER JOIN ON Parts.[SUPP ID#_2]=Supplier.SupplierID) INNER JOIN ON Parts.[SUPP ID#_3]=Supplier.SupplierID;
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •