The (1) and (2) under the background statement, is the current process being used, using several Access queries and a couple of pass-thru queries to SQL.
I would have though the the VBA approach is faster than the Access Query approach, but not as fast as a SQL approach. I may look into the...