Thank you both!
I did end up creating a view on SQL Server and linking it to Access and that did the trick. That process was a learning curve for me, but the effort was well worth the end result because it handled the processing efficiently enough. Now I'll just need to create a few more...
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...
Hi,
I'm rather new to Access and VBA. It's been well over 10 years since I've dabbled with it (i.e. create a couple simple applications to solve some smaller issues), so I'm re-learning some aspects, but largelylearning aspects for the first time because I need to solve more complex issues...