I hope this works the way you want it to. By the way this was a Nice little Report that came out.
--Side Note, This has a Left Join to make sure that if there are no Interfaces Assigned that it will still report the Node with no Interface. I took out the NodeID and InterfaceID to clean it up, and also added the Node Status.
SELECT max(Events.EventTime) AS Event_Time, Nodes.Caption AS NodeName, Nodes.StatusLED as Node_Status, Nodes.VendorIcon AS Vendor_Icon,
Interfaces.InterfaceIcon AS Interface_Icon, Interfaces.Caption AS Interface_Caption, Interfaces.StatusLED AS Interface_Status_Icon
Inner JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
Left JOIN Interfaces ON (Interfaces.NodeID = Nodes.NodeID)
((Nodes.Status = '2') AND
((Events.EventType = 5000) OR
(Events.EventType = 1)))
((Interfaces.Status = '2') OR
(Interfaces.Status = '0'))
Group by Nodes.Caption, Nodes.NodeID, Interfaces.InterfaceID, Nodes.VendorIcon, Nodes.Caption, Interfaces.InterfaceIcon, Interfaces.Caption, Interfaces.StatusLED, Nodes.StatusLED
ORDER BY 1 DESC
Your work is TOP NOTCH ! This reports looks even better than what I imagined. Thanks for your help, great job!