Addition/Subtraction

[Steph]

I am very new using access. I have put together a small inventory database.
I have a items table, disbursement table and receiving table. I want to pull
the number together into one report. example: Mop -- 10 in stock (items
table), disbursed 7(disbursement table), recieved (received table)4 total
should be 11. How do I run a query to add and subtract and also show what
is currently in stock (items table)? I have been able to create a report
that will show me what has been disbursed and received total but if there is
inventory in the main item table and that item has not been disbursed or
received any additional inventory then it will not show on the overall
report. Thanks for helping out.

 

[Allen Browne]

Take a look at this article:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

The article explains how to calculate the quantity in stock based on:
- quantity at the last stocktake (or initial quantity),
- plus acquisitions since then,
- less sales since then.

It does require some understanding of VBA code.

 

[Steph]

Allen,
Thank you! I did print this article yesterday afternoon however I am not
familiar with VBA Code. I will try and get familiar with VBA.