Stock balance

[tgb]

Hi Guys,
I am very new to access.
I have three tables.
Table 1; Part number, Description, stock.
Table 2: Part Number, qty issued, date issued.
Table 3; Part number, qty received,
I have created a qry to calculate the balance in stock using a simple formula: ([Stock] [qtyReceived]) - [qtyIssued].


I can get the results but only if there has been an issue. it is not showing whatever balance is there in table 1.
I have been sitting on this for the past 1 week and have read a lot but nothing. Please help.

[orange]

Since you are very new to Access and to this forum, I recommend you use Google or the search option on this page, and search for

Inventory Control
Stock Control
Inventory Quantity On Hand

and review the posts you find.

Also see this link Allen Browne AppInventory

I really suggest you learn some database concepts before stepping into Access. This tutorial will help with concepts and design, if you work through the sample.

Good luck.