Thanks, Mark McCasland came up with the key. The problem was in getting a bizarre combo of joins with too many or few records or erroring out. works now. Thanks again. Jeff