To Nick, Nadya, Mike and Doug,
Thanks for help guys and gals. I went with nvl(xfield, '') in the report column so that I can still see the .null. in a browse.
>> 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.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn