ok...i create 2 table
First table :- item number and total qty
second table:- item number, in qty and out qty
I created main form using the first table and then use second table to become
the subform.
Which means each subform will display only the related item according to the
item number.
This means each item can have in and out many time (in and out products).
Now i want to sum up the total qty just for that particular item number.
For example Mr A key in 6 qty for Item A.
Then Mr B key in another 10 qty for item A.
So, i need a textbox to sum up the 16 qty. The sum will remain there forever
and will keep increasing....
Can help?