It's 3 tables - one for each company, so they would all be corrupt. I'd love to test out your suggestion. This client has SOX compliance procedures associated with any move I make on their system, so it will take an act of Congress to do any testing. They don't even know there's an issue. Question becomes: is data successfully being imported into the tables? The company with 0 records has not yet processed an import (new requirement), Maybe we'll see how that goes and see what the next step is.