Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2016
    Posts
    1

    Unanswered: Received quantity distributed based on order number and order date

    Hello,

    I'd like to perform a report based on 2 tabless (Order Table and Reception Table):


    Order Table
    OrderID (PK)|Item(PK)|Ref|Qty|Order Date
    1|1|Orange|5|20/01/2016
    1|2|Orange|3|22/01/2016
    1|3|Orange|2|22/01/2016

    Reception Table
    RecpID|OrdernumFK|Qty|ReceptionDate
    1|1|2|22/01/2016
    2|1|7|23/01/2016


    Via a request, I would like to be able to fill a table like this

    Table request (Reporting)
    OrderID (PK)|Item(PK)|Ref|Received Qty|
    1|1|Orange|2
    1|1|Orange|3
    1|2|Orange|3
    1|3|Orange|1 (it remains 1 qty to full-fil le line)

    Would it be possible to perform something like that in access?
    I would like to distribute the received qty based on order num and order item + date of recpetion of the good?

    I have programming skill on vba on excel 2010, I think it might be possible to use it for access 2010?

    Thanks beforehands for your help.

    Arte

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    see my comment on other board

Posting Permissions

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