Search results
-
V
running total
thaks for your reply Neil. I just trying to find an easier way . I know that storing calculated fields in a table is a bad idea but I am not sure how else to do this. TABLE 1 pn qtyonhand A 50 TABLE 2 CUSTO PN SHIP DIFF ADF A 45 5 (50ONHAND... -
V
calculate difference on every entry
Use a query. New field - Difference:[QtyOnHand] - [ShipQty] Although shipping 10 when you've only got 5 seems a bit odd. It would be better to have the check done afterUpdate of the QuantityToBeShipped field so the you can have a message saying "Not enough for this order" or something...- villica
- Post #3
- Forum: Modules & VBA
-
V
calculate difference on every entry
I have two tables. one is stock and the other one is shipping information Example Table Stock PARTNO QTYONHAND A 50 B 25 C 5 D 10 E 20 EXAMPLE OF TABLE SHIP CUSTOMER PTNO SHIPQTY DIFFERENCE ABC A 45 5 BDF A 10 -5 CDF A 50 -55 AER B 1 24 I Don't know how to get the difference...- villica
- Thread
- Replies: 2
- Forum: Modules & VBA
-
V
calculate on every entry
I have two tables. one is stock and the other one is shipping information Example Table Stock PARTNO QTYONHAND A 50 B 25 C 5 D 10 E 20 EXAMPLE OF TABLE SHIP CUSTOMER PTNO SHIPQTY DIFFERENCE ABC A 45 5 BDF A 10 -5 CDF A 50 -55 AER B 1 24 I Don't know how to get the difference... -
V
running total
I have two tables. one is stock and the other one is shipping information Example Table Stock PARTNO QTYONHAND A 50 B 25 C 5 D 10 E 20 EXAMPLE OF TABLE SHIP CUSTOMER PTNO...