Whats the code to Update current stock level

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

In Access, if you have your Inventory in one field, then you can employ a group by Query with Sums to give you an net inventory balance.

Assume you have two fields, Product and Quantity in Table 1.

Here is the SQL statement

Please Login or Register  to view this content.