Hi,
I've been searching for the best way to automatically pass a list of parameter values to an append-table query I have. I have a separate table that has about 30 sales rep names in it and I want to be able to run my sales performance query for each rep without having to type their names one by one into the query prompt. The SQL for this sales performance append query is about a mile long and I'm guessing my only solution would be to embed the SQL into VBA and somehow pass the query parameter values through a loop but I can't seem to find any information on doing this.
Any help would be appreciated.
Thanks