Sharon....
>>IIF(addr_1=space(30),"",addr_1+", ")+IIF(addr_2=space(30),"",addr_2+", ")...
Not sure why above is failing but You might try.....
if empty(addr_1)
mstr=""
else
mstr=alltrim(addr_1)
endif
if empty(addr_2)
mstr=mstr
else
mstr=mstr+', '+alltrim(addr_2)
endif
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw
