I have what may be a strange need that I could use some help with. I have a database that keeps track of air packs from a fire department. It maintains their service and repair history as well as what truck each pack is assigned to. Each year we have to retrieve every pack and they get tested for proper operation and to make sure they are still working within their design specs (we call that PM or preventative maintenance). I currently have two tables that I'm using to track them. Table 1 (tblEquipment) has the pack's serial number, county property number, unit their assigned to, an auto-number (EquipmentID), and a couple other identifying parameters. Table 2 (tblMaintenance) tracks the service and any repairs made to each pack and consists of its own auto-number (MaintenanceID), EquipmentID (foreign key), the date the service was done, a description of the service performed, the service type (PM, repair needed, repair completed), and a note field, along with the name of the person entering the service. All of that is working great. The issue I need help with is a report for the yearly PM. I'd like to have a report that we can use visually to see what packs have been completed and what packs we still need to find and test. I've made a button that we can click on the pack's page that inserts a record into the maintenance table that basically says the testing was complete for that pack for the current year. I'd like a report that shows the packs grouped by the truck they're assigned to and if the pack still needs to be tested it would be red and if it has been tested, it would turn green. I've attached a paint image to this post that gives an idea of what I'm looking for. The part that is hanging me up is that I know you can't conditionally format a label, and I don't necessarily need any fields on this report. It basically just needs some text that changes color based on records in the Maintenance table. Is this something that can be done? If so, I'd love to hear how. Thanks in advance.