As I was looking at the SQL word by word I noticed in the AND statement the word PartNo. The correct name is Part. I have changed this and now it appears to be working. When you stare at something wrong long enough it looks right.
I apologize, I screwed up here. I should have seen that right off. I appreciate all of your input into my problem (which was my problem) and as usual you have me working. Jal thanks for the tip on the possiblity of double entries; until you said it it hadn't entered my mind.