Hello,
I have a specific task to do, and I think MS access is the way to go. Im coming from excel programming (VBA), but access is totally different.
Im trying to implement a database to use it in our company - but first I would like to design it on paper, and I have a problem which I dont know how to solve.
We have lots of printers which we are renting out to companies. The printers have lot of details in the databes (Brand, Type, SN number, IP Address, fees, etc), and the most important thing is, that how much page is printed with that particular printer every month. So to every printer, every month I have two numbers; mono and colour page count. (forexample: 2020 January printouts: 3111 mono page and 2343 colour page, 2020 February 1576 mono and 2678 colour printout, etc) and I need to track this for every printers (we have hundreds) and every month. What is the best way to do this? Make a table with 12 months on it and connect to printers? But what if we change year? Or what is the best method to do this?
Thank you