Inventory Tracking

[PUDrummer]

I'm trying to create a basic inventory tracking database for multiple products. I have a table of products, purchases, and sales. The common field is ProductName, which is my primary key in products. I managed to make 2 seperate queries totaling the purchases and sales by product. What I need is a table combining the two and subtracting sales from purchases to give me the total inventory of each product. I know this isn't too difficult but I haven't messed with Access in 5 years or so and am coming up blank. Thanks for any help anyone can give me.

[SoftwareMatters]

Moving forward with this database I think it would be a good idea to have a CurrentStock field in your products table that gets updated whenever there is either a sale or purchase. This would then give you on-the-fly stock reports.

Regards
JD

[jbarrum]

There was a previous post that offered a solution for what you are trying to do. Read the following: http://allenbrowne.com/casu-14.html

[NVRensburg]

HI there, I'm trying to do the same thing - I'm trying to do away with the bin cards and use an inventory system. I want to input the part number, insert qty rec'd in or qty taken out and a description. i.e. part number 123ABC 12 out for ABC Company. And then just a report on each item what went in and out and the value left. Can someone send me a sample of one they've done?