Results 1 to 2 of 2
  1. #1
    pdxengruser is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    1

    Searching for match in table

    I have a list of products (each row, unique) that are made using a specified material (A, B, C, D, E) which is column B (the spec matl is what the product SHOULD be made with), and the actual material that the material is being made in which is column C. I know that column B (spec matl) does not match column C (actual material).



    I also have a table that lists acceptable alternate materials for each specified material:

    Spec Matl Alt Matl
    A A
    A B
    A C
    C C
    C E

    I am having trouble using a query to find if for a particular product, the actual material for that one product matches any of the alternate materials (I have the spec matls for both tables linked). If it does then I do not want to see it in the results. The problem that I have had is that if the spec matl is A and the Actual material is B, then from the table above:

    Spec Matl Alt Matl
    A A
    A C

    would be returned which leads me to beleive that this product is being made with a wrong alternate, which is incorrect.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    your post is very difficult to understand - primarily because you use sample data abcd and also call your columns abcd.

    I suggest you make a new post showing a few lines of actual names - as really is.

    And then a few lines of what result you need...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. Replies: 13
    Last Post: 03-28-2011, 02:09 PM
  3. Replies: 1
    Last Post: 12-02-2010, 04:54 PM
  4. Replies: 1
    Last Post: 11-05-2010, 04:51 AM
  5. Match up table using only a few charecter?
    By bangemd in forum Queries
    Replies: 5
    Last Post: 06-05-2009, 04:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums