Temp tables made a tremendous difference in this case. After changing all of the table variables to temp tables the query finished in around 27 seconds.

Thanks for the reply Grant.

I'll try the temp tables and see if that helps any. This version of the code is a variation of code in which I had originally...

Luke -- I've made a correction to my original post. The application is actually built in Access using Access forms and VBA code behind them. The label report is for...

Thanks for the info. I'm quite new to SQL -- where do I find the client tools to install on my desktop?

Thanks,

Ron