Strange Problem

It may be a simple problem I don't know. I have to do an inventory control database in Access for my Systems Design paper however I am having an issue with queries.

I have a query called Item Status Check and it asks the user for the item code and goes in a table called Inventory Item to get the results. Now the problem is after I added a whole lot of new items (I had some from testing earlier) it does not bring them up in the query at all, its ignoring them basically.

Now I find this strange because other queries like suppliers etc still work fine and access any new data I put in.

I know its going to be simple but its doing my head in.

EDIT: Found more.

The ISC query has the following field

ITemID
ITemName
SupplierID
CarryCost
RetaiPrice
StockMin
StockMax

StockOnHand <--- from a stock on hand query.

Now if I delete the stockonhand it shows all the stock so thats the problem. The way I have calculated stock on hand is to simply take all the purchase orders, add them together and subtract the customer/production order numbers. I don't know why this would happen

EDIT 2

found the problem, need the solution

In the StockOnHand calculation is takes all the number of incoming stock and subtracts the outgoing stock to get its answers. If the stock isn't on one of each of the incoming/outgoing forms it doesn't show it at all.

EG

Incoming Stock:

Purchase Orders
Add Stock (from an alter stock form for discrepencies)

Outgoing Stock:

Customer and Production Orders
Remove Stock (alter stock form)

If items have not been used on 1 of each of these they don't show up in queries with StockOnHand.


Thanks in advance