Ugh! That makes sense! I am teaching myself SQL and I had already written the code when a guy from our software developer told me I should do it that way instead of how I was doing it. My way would have been the right way then! So much time lost. Thank you. I will make some changes and let you know if that corrects it. Couldn't I just take out the TOP 1 verbiage?

UPDATE: I took out the TOP1 on all select statements and I am still only getting one record. Any ideas?