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
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