How do I update inventory quantity records?

[Guest]

Is there a way to update my inventory quantity records in my inventory table?
To me, the formula would be: quantity on hand - quanity sold = quantity
remaining. However, I did not sell every type of inventory. Those that
weren't sold, access leaves that "quantity remaining" cell blank. so how do
i get access to give me an answer? Is there a way around this?

 

[Allen Browne]

Use Nz() to convert the blank cell (Null) into a zero, e.g.:
[quantity on hand] - Nz([quantity sold],0)