The basic idea:
I need to run an existing make table query in a database without the user's
intervention. I have tried some code I have found online but none work (thus
far).

The complete pictu
Same as above, however, I would need to be able to pass along a user input.
In this case am I better executing an SQL statement from Excel to Acces? If
so, how?

Could someone point me in the right direction.

Thank you,

QB