Recent content by jland

Hello Sir, Yes it worked! Only that I have to place your suggested criteria in the "OR" row. It doesn't return anything if I place it at the same level with the Product Description Row. Could you please explain to me why? Or whats happening? Thank you sir. Thank you indeed! :)

I've tried this already. It works only if I don't delimit the query to a given date interval. Once I add the date interval criteria then the null records won't show anymore.

Hello Isskint, Thanks for the reply. I've attached a picture of the query. Thanks. :)

I made a very simple Inventory for our small stock room. The tables are Lens Products and Inventory Transactions. I made and enforced a relationship between the two tables using the ItemNo Field. What I want to do is make a query that would calculate the stock movement [Out] on a given date...