Hi Everyone,

Sorry for the delayed response but I had some personal things to take care of.

I appreciate everyones help with this and the great suggestions.

I ended up doing some research...

Hi Joe,

I'm not sure how an outer-join could do what I need to do. The problem stems from the fact that any single instructor can and probably will have multiple...

"set-based solutions"....Can you explain what you mean?

Mitch 

Jo,

Thank you for the fabulous help!!!

I was able to use the info (pivot tables) and example you gave me and the report which used to take 40 seconds to run and generate...

Hi Jo,

Here is a link to the image, I think it will help explain what I am trying to do:

http://www.fotash.com/new1/sto_sample.gif

Thanks!

Mitch

Silly Me...I guess I should have really read the message. The below code solved the problem:

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim objFSO

Dim objFolder

Dim objFile

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFolder = objFSO.GetFolder("C:\temp\")

For...