Page 1 of 1

Move Address2 into Address if Address is empty.

Posted: Thu Aug 15, 2013 2:29 pm
by Donna
If you have ADDRESS 2 information but your ADDRESS is blank. The following command will move the ADDRESS 2 information into the ADDRESS. If the ADDRESS field is empty.

Code: Select all

Replace address with ALLT(address2),address2 with "" FOR EMPTY(address)