>Hi all,
> 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.
>
>
>Many thanks in advance to all the helpfull people at this site.
John, you can put
NOT ISNULL(myfield)
into Print When condition for the report field.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison