Recent content by CodeJohnny

Agree completely with you Moorracr, however I've run into two problems with the other code, and then your changes. 1. the other code was doing a left(x,3) to find WSS which shows up as ACEWSS; in the .Connect string of the table object in the loop. I see you're not checking this at all though...