Recent content by Chunny

Thanks for suggestions. Yes, I will add "Date" field in the "Movement" table. This project is only for different products inventory, so I don't have to capture "PartNo". I want to capture the total number of each product. I plan to do it in Query, by using Sum of Movement "in" less Sum of...

Hi, I'm new here, and a very beginning Access user. I'm working on a project to create a simple inventory tracking database. I have created tables as follows. Product - Code - Name Movement - Number - Movement ("in" or "out") MovementDetail...