Calculating Current Stock in Inventory/Warehouse

[yohansetiawan]

Hello,
Here's the things I've got.
I created database that contain these tables:
- Products
- Orders
- SubOrders
- Inventory/Warehouse

Here's the problem, I want to calculate my current stock in my warehouse sort by product I've got.
How do I do that?
In case I've already make some queries to calculate this current stock but I got stuck because these queries can only calculate my total IN and OUT from my warehouse separately. I tried to make another query that can calculate IN&OUT together but I failed to do that.
My "Inventory/Warehouse" table is things that IN of my warehouse (so that's addition)
My "Orders" and "SubOrders" tables are things OUT of my warehouse (this is removal)

Could someone help me to make "Inventory CURRENT STOCK" for me?
I really confused with this.
Here's I've attached my database.

n.b. I already checked "Inventory" template from microsoft office itself, but that isn't that I want.



THIS IS THE SOLUTION

Start a new query. Add the products table and you IN and OUT queries to the grid. Click/drag to draw lines between the Product field in the products table and the product field in each of the queries. Right-click on the resulting join line to edit it. Choose the appropriate selection. Add the desired fields from the table and queries to the grid and run the query.

[pbaldy]

You create a query starting with your products table, and LEFT JOIN each of your other 2 queries to that table. That should get you every product, and any in's and/or out's they've had.

[yohansetiawan]

I really don't understand to do that, there is my database in my first post though.

[pbaldy]

Start a new query. Add the products table and you IN and OUT queries to the grid. Click/drag to draw lines between the Product field in the products table and the product field in each of the queries. Right-click on the resulting join line to edit it. Choose the appropriate selection. Add the desired fields from the table and queries to the grid and run the query.

[yohansetiawan]

it works...!!!!
thank you so much pbaldy
REALLY APPRECIATE YOUR HELP!!!

[pbaldy]

Happy to help, and welcome to the site!