David,
The second method is faster by far. It seems that the more rows that are deleted the slower it gets. Ran the second option first and it just flew thru the process the second one is running now and it is going to hours. I am just going to have to stop it. Will use the new concept Thanks David and Razzak
