Hey guessed I was able to get your code to work. This has made my work far easier allowing me to delegate more time to the rest of the report. I'll try to see if I can figure out how to get the macro to cancel without waiting for it to finish, but for now I am more than pleased.