Nailed it!! This does exactly what I need. I can't thank you enough. If I can ask, what kind of query is this? Specifically, what is the C.EquipmentID doing?
Always better to provide data which truly reflects the real life situation. You need a different type of query
Code:SELECT tblEquipment.Unit, tblEquipment.Position, [c].[equipmentID] Is Not Null AS serviced FROM tblEquipment LEFT JOIN (SELECT tblMaintenance.EquipmentID FROM tblMaintenance WHERE (((tblMaintenance.MaintenanceType)="PM") AND ((Year([MaintenanceDate]))=Year(Now())))) AS C ON tblEquipment.EquipmentID = C.EquipmentID WHERE (((tblEquipment.Unit) Is Not Null));
it's from this part of the query
I named it C (known as aliasing) as just a short name for 'current' - shorter words, less typingCode:(SELECT tblMaintenance.EquipmentID FROM tblMaintenance WHERE (((tblMaintenance.MaintenanceType)="PM") AND ((Year([MaintenanceDate]))=Year(Now())))) AS C
the query is just selecting the records for each equipment which qualify as 'currently serviced'
you could write this as a separate query and join it to the equipment table instead if you wanted to
Ok, I think I got that. So much to learn.....Thank you again for all of your help. I do appreciate it.