I am trying to set up a database so I can deliver cleaner reports to all involved. I have been tracking printers, copiers, and Large format printers we lease for 4 years now. Every month I take the numbers and list them out into a spreadsheet with total color for that month and total black and white for that month. at the bottom of the spreadsheet, I do the calculations for how much we spent on color and black and white plus the lease cost so accounting will know when they get the bill it is right. Then I generate a separate report for all printers and copiers that are in production so they can see if the numbers are going up, going down, or staying the same. Below that, I show the numbers from the previous year for comparison. Every year I add a new tab and start the year over. I feel like I can do this easier in a database.
- How do build the table for each copiers, printers, and large format?
- How do I show the costs?
- How do I change over every year new database new table?
- Once I have a database built I would like to work on reporting after the database is set up.