Thank you plog!
I'm in the process of trying out your first query "LateInspections_sub1", which looks very promising, and thank you for providing it. However, something I didn't mention was that my original query returns over 100,000 records, and so I'm running into performances issues...