I would like to track printer usage and identify underutilized printers. I collected information from the printers showing the number of B&W pages, the number of color pages and the date checked.
I would like to be able to update the page counts and then run a report showing the number of pages printed and the number of work days between the dates checked.
The goal is to identify printers that aren't being fully utilized. I have been trying to use the DMax function to select the records with the latest date checked. I am not sure how best to go about identifying the latest counts, vs the previous, etc..
I would like to be able to collect the usage data at regular intervals and then produce a standard report.
Any help that can be provided is appreciated.