I am not going to store the result of the calculation what I need is just a
"display" for the user's reference.
Just as the Nortwind's Order Form, the ExtendedPrice is displayed once the
UnitPrice, Quantity and Discount is inputted.
On the other hand I want my Form to display the SumOfDeliveredGoods for a
particular WorkOrder once another set or quantiy is inputted for delivery.
Noting that the delivery still belongs to thesame WorkOrder.
E.g., a Product is being produced and assigned with WorkOder and WorkOrder
Quntity say 1000 units. These units will be delivered staggered say 200 on
the first day and 200 on the second day and so on until the 1000 units is
met. That is why I need a display of reference so that the user will be aware
of the units that were already disposed and that the present delivery will
not exceed the required WorkOrder quantity.
This routine will continue for a particular Product and only the WorkOrder
is change and its required work order quantity.
Ty...I hope this explains a lot and not confusing you.
Arvin Meyer said:
It is not necessary to store the result of a calculation unless that
calculation cannot be reproduced and is required in the future. (For
instance a payroll total). You can display the total in a form or report.
Use the form or report's footer for a total if you have a subform. The
textbox control source should look like:
= Sum([DeliveryQuantity])
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
bxyle said:
My objective is to have a cummulative.
My table have [Product], [WorkOrderNumber], [DeliveryQuantity] and so on. I
want my form to display the "total quantity" of deliveries pertaining to the
[Product] and [Workorder] that I am going to input.
e.g.
I will use subform:
Product A, Work OrderX, DeliveryQuantity,
TotalDeliveredQuantityBelonging to ProductA and WorkOrderX.
