Hi,
I need help solving next problem:
I need to calculate Sum of the QTY from the Table1and store it in a variable.Table1 has OrderID,orderline,reldate,QTY fieldsIt looks like:
Order orderLine reldate QTY
111 1 3/1/01 20
111 1 4/1/01 10
111 1 5/10/01 34
111 2 3/2/01 10
111 2 4/10/01 20
111 3 3/25/01 25
111 3 4/30/01 39
I need to sum QTY for the orderID and orderline I want and as long as reldate<date .I thought about having function
SumQTY=Func(OrderID,orderline,date)
that will for those arguments loop trough Table and as long as The order=OrderID and line=orderline and reldate<date calculate sum of QTy and return result and assign it to that valiable SumOTY.I don't know how to do it
Any help welcomed
Lyn
I need help solving next problem:
I need to calculate Sum of the QTY from the Table1and store it in a variable.Table1 has OrderID,orderline,reldate,QTY fieldsIt looks like:
Order orderLine reldate QTY
111 1 3/1/01 20
111 1 4/1/01 10
111 1 5/10/01 34
111 2 3/2/01 10
111 2 4/10/01 20
111 3 3/25/01 25
111 3 4/30/01 39
I need to sum QTY for the orderID and orderline I want and as long as reldate<date .I thought about having function
SumQTY=Func(OrderID,orderline,date)
that will for those arguments loop trough Table and as long as The order=OrderID and line=orderline and reldate<date calculate sum of QTy and return result and assign it to that valiable SumOTY.I don't know how to do it
Any help welcomed
Lyn