I have several tabes linked together by a left outer join within crystal. Now for most instances it works wonderfully. However, in the event that a vlaue is not found, it simply displays an empty field. This is quite odd as I am using a summation off of this, and I thought it would be a zero if nothing was found. I have tried many ways to get the value to default to zero but none have worked. Have tried converting to a string and checking for null, doing a count of characters and if zero= 0 but nothing works. Does anyone have any suggestions?