I have created an inventory database. I have a received, used, and amount of stock fields. I would like to input amount received and have it automattically calculate my amount of stock, and when I enter amount used (out) I would like my amount of stock to automattically calculate that as well. I have set up the fields received & used as numbers and amount in stock field as a calulation in Boolean.
It is not calculating correctly. I am a new user, and require some help.
What am I doing wrong, for my stock not to be calculating?
Thanks to all who help and respond.