I've recently been rethinking the approach I took in solving the problem in Access with dynamic SQL. Most of the code was just strung together query logic mixed in with VB.