Hi John.

> I finally figured out how to do a left outer join but in the fields with no match I have .NULL. showing in my report column. There must be a simple way to remove it but I haven't worked with nulls before.

SET NULLDISPLAY TO '' will cause nulls to appear as blanks.

Doug