Peter,

I appreciate your insight and showing me a new way of looking at this problem. It may seem obvious for some people, but once you get to looking at something...

Well the good news is, you have comfirmed that I am not loosing my mind either, thanks.

Now on to the problem,

Lets look at the 2 rows I specified earlier

PartNo     JobNo        Qty_Comp       ...