Results 1 to 4 of 4
  1. #1
    Almira3 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    3

    Exact Match, Specified Criteria

    Good Day,


    I am very much a rookie when it comes to access, and I am trying to use it for analysis that I feel is far beyond excel, and I am not ready for SQL.

    I have attached the excel file of data, as the Access file would not load.

    What I would like to do, is get a list of of orders where the INV_ITEM_CAT is Labor and SOURCE - PROPRIETARY, ONLY on that order. The order numbers can be found in the first column "ORDER-NUMBER".

    When I do a query I would like to find the orders that only have LABOR & SOURCE - PROPRIETARY on them, no speakers or amplifiers or anything else. This way I can pull in the rest of the data and analyze.

    I hope this makes sense, and I thank you sincerely for any help given.!
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    If I understand correctly, you will need three queries.

    SELECT [Standard Work Times].ORDER_NUMBER, [Standard Work Times].ORDER_TYPE, [Standard Work Times].SUB_TYPE, [Standard Work Times].ORDERED_ITEM, [Standard Work Times].ITEM_CATEGORY, [Standard Work Times].INV_ITEM_CAT
    FROM [Standard Work Times]
    WHERE ((([Standard Work Times].INV_ITEM_CAT)="Labor"));

    SELECT [Standard Work Times].ORDER_NUMBER, [Standard Work Times].ORDER_TYPE, [Standard Work Times].SUB_TYPE, [Standard Work Times].ORDERED_ITEM, [Standard Work Times].ITEM_CATEGORY, [Standard Work Times].INV_ITEM_CAT
    FROM [Standard Work Times]
    WHERE ((([Standard Work Times].INV_ITEM_CAT)="SOURCE - PROPRIETARY"));

    SELECT Labor.ORDER_NUMBER, Labor.ORDER_TYPE, Labor.SUB_TYPE, Labor.ORDERED_ITEM, Labor.ITEM_CATEGORY, Labor.INV_ITEM_CAT, Prop.INV_ITEM_CAT
    FROM Labor INNER JOIN Prop ON Labor.ORDER_NUMBER = Prop.ORDER_NUMBER;

  3. #3
    Almira3 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    3
    Removed - No Longer Valid

  4. #4
    Almira3 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    3
    I was able to get the two lists to Join. The problem being, that it pulls orders with more then Just Source - Proprietary. I need to be able to isolate orders that only have Labor and Source - Proprietary on them, they can not have anything else. You can look at order # 1087068 on the excel I posted, that has multiple inventory items (column F) (may help to sort by order #) on the order. Order # 1093531 has only the two inv item cat, I am looking for. I am trying to group these orders by what items are on them and put them in categories. Source - Proprietary and Labor would = Source - Proprietary only.

    I hope this helps clarify, as I have learned a ton already.

    Thank You!

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

Similar Threads

  1. Exact Match Query
    By KCC47 in forum Queries
    Replies: 1
    Last Post: 11-07-2014, 10:21 AM
  2. Find an Exact Match in a Access Table column
    By raghavendran in forum Access
    Replies: 4
    Last Post: 10-12-2013, 11:57 AM
  3. Replies: 3
    Last Post: 09-12-2013, 02:18 PM
  4. Exact Match Hyperlink
    By JeffG3209 in forum Access
    Replies: 5
    Last Post: 06-23-2011, 07:46 PM
  5. Dlookup to match two criteria and return value
    By randolphoralph in forum Programming
    Replies: 20
    Last Post: 05-20-2010, 12:27 PM

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