i need to find the latest value from a table so that i can count on it. For example, Table A have Field QuantityOnHand(QoH) and it show 10.
Table B have field name issue Qty.
Then how can i do a program to minus QoH to 8 when i key in 2 in field Isue Qty?
I hear that recordset can do it,but i'm just a beginner to access. Can anyone help me?
Table B have field name issue Qty.
Then how can i do a program to minus QoH to 8 when i key in 2 in field Isue Qty?
I hear that recordset can do it,but i'm just a beginner to access. Can anyone help me?
