Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would enter the quantity they are putting on the stock. For example, TOM puts 150 pcs of -product1- in stock. Then Bill will take 50 pcs of the same product1. So the system would do the calculation: 150-50 = 100 pcs left in stock. When TOM will put again 110 pcs of product1 system would do the calculation again: 100 + 110 = 210 pcs in stock. The system would show "REPORT in another table". I used the MS Access database to create a database. But I don't know how to make an REPORT table to get date from other tables and do couting. Then I want to use Visual studio control to database. I can't find any help...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.