Quote Originally Posted by Simply Me
Can we just use the fields i am using so that i'll not get lost in the processing of our discussion?
Your field names or my field names are not an issue.

Tell me what is the purpose of Quantity and QuantityOut in tblStockTransFile?

Why do you have two fields?

My example in Post #2 of this thread clearly shows that a single QUANTITY field is sufficient.

Granted I propose a CREDIT/DEBIT field to determine if it's a "in" or "out" of inventory - but it would be even simpler to remove the CREDIT/DEBIT field and simply have the QUANITY be a positive or negative number.

What is the purpose of your UNIT field??