Jim,

I should have elaborated more, each part no can occur more than once in a table, because they are related to different projects, as well as being in-house or customer. My dilemma is trying to get a count for each individual part from 2 separate tables.

Perry