var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Received quantity distributed based on order number and order date
I'd like to perform a report based on 2 tabless (Order Table and Reception Table):
OrderID (PK)|Item(PK)|Ref|Qty|Order Date
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|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.
see my comment on other board