Printers_Test.accdb

Supervisory Operations Support Specialist

Michael Spellman

<div>
That is great. &nbsp;I have been trying to get the DMax function to work, but kept getting #Errors instead of numbers. &nbsp;I'll just have to address the circumstances where the counts are zero because the printer wasn't working.
</div>


That is great.  I have been trying to get the DMax function to work, but kept getting #Errors instead of numbers.  I'll just have to address the circumstances where the counts are zero because the printer wasn't working.

<div>
<div class="content wysiwyg-content">
I would like to track printer usage and identify underutilized printers. &nbsp;I collected information from the printers showing the number of B&amp;W pages, the number of color pages and the date checked.<br />
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.<br />
<br />
The goal is to identify printers that aren't being fully utilized. &nbsp;I have been trying to use the DMax function to select the records with the latest date checked. &nbsp;I am not sure how best to go about identifying the latest counts, vs the previous, etc..<br />
I would like to be able to collect the usage data at regular intervals and then produce a standard report.<br />
<br />
Any help that can be provided is appreciated.<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/11_w45/1435784/Printer_Pagecounts.xlsx" target="_blank" class="file-inline" title="Spreadsheet with print counts calculated.  Differences from date to date (25 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Printer_Pagecounts.xlsx</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2019/11_w45/1435798/Printers_Test.accdb" target="_blank" class="file-inline" title="Table with Printer usage data, query showing total usage by printer by date checked. (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Printers_Test.accdb</a>
</div>
</div>


Table with Printer usage data, query showing total usage by printer by date checked.

Spreadsheet with print counts calculated.  Differences from date to date

Printer_Pagecounts.xlsx

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.

How can I report printer usage (page counts) over time?

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.