Results 1 to 4 of 4
  1. #1
    fjhlad is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    3

    Get data from row in a table using information in first record

    I have a projected inventory table. The DateReqd field is the date I need parts fabricated. I need to fabricate enough parts to cover requirements until the The DateCover field (not to exceed this date). I want a SQL query that will report for each PARTNO, the date "A" and the quantity "B". PARTNO, PARTNAME, NEEDBYDATE, QUANTITY
    Attached Thumbnails Attached Thumbnails InventoryFile.PNG  

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Since you have posted a graphic , I recommend you provide:
    -an overview of the business/application to give readers some context
    -a copy of your evolving database with only a few records

    Perhaps an example to show us what Partname represents, and what exactly "Life" entails.

    Good luck and welcome to the forum.

  3. #3
    fjhlad is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    3
    table has different part numbers and a projection of inventory required, declining over time with demand. When inventory goes negative, that DATEREQD is the date we need to replenish. The question of how many pieces to make is answered by future demand. The product's shelf life is listed in DATECOVERED column. We need to read down the DATEREQD column until the find out how many pieces we need to make to cover the requirement. LIFE and PARTNAME don't matter to the calculation

    PARTNO DATEREQD PCS DATECOVERED
    abcde

  4. #4
    fjhlad is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    3
    PARTNO DATEREQD PCS DATECOVERED
    abcde 09/29/2019 -19 10/06/2019
    abcde 10/01/2019 -32 10/08/2019
    abcde 10/03/2019 -47 10/10/2019
    abcde 10/06/2019 -67 10/13/2019
    abcde 10/09/2019 -81 10/16/2019
    bcdef 09/27/2019 -9 10/03/2019
    bcdef 10/01/2019 -37 10/09/2019
    bcdef 10/06/2019 -82 10/13/2019

    I need to return
    abcde 09/29/2019 -67
    bcdef 09/27/2019 -37 etc. Those are the DATEREQD values from RECORD1 and the PCS corresponding to the RECORD1 COVERDATE as looked up in the DATEREQD column

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

Similar Threads

  1. Replies: 6
    Last Post: 03-14-2019, 03:39 PM
  2. Replies: 10
    Last Post: 06-02-2017, 08:20 AM
  3. Replies: 12
    Last Post: 04-14-2017, 03:17 PM
  4. Replies: 3
    Last Post: 03-07-2014, 10:39 AM
  5. Track changes of raw table data information.
    By jacjacjac in forum Access
    Replies: 7
    Last Post: 12-23-2012, 10:02 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