Thanks for the info Mark. I may have tried to un-nest the joins but I am going to try again. I mus admit it did look strange in the view designer with the Joins grouped togeter and the ON statements grouped together.

I was wondering in haveing the two left joins were legal in one SQL statement.