rpaterick Posted December 16, 2010 Share Posted December 16, 2010 If address line 2 is blank, I just need it to return a name. If it has a value in the data, I need it to be blank. ex: John Smith <value> <would return a name here 123 E. Way Street Anywhere, WI 54729 Suzie Smith <no value> <would be blank 456 E. Way Street Apt. 32 <has an address 2 Anywhere, WI 54729 Link to comment Share on other sites More sharing options...
rpaterick Posted December 16, 2010 Author Share Posted December 16, 2010 I think I may have figured it out.. if (Field("Address Line 2") == "") return "Attn:Purchasing Department"; else return Field(""); Link to comment Share on other sites More sharing options...
Dan Korn Posted December 16, 2010 Share Posted December 16, 2010 I think I may have figured it out.. if (Field("Address Line 2") == "") return "Attn:Purchasing Department"; else return Field(""); I think the last line should just be: return "";You could also write the entire rule like this: return Field("Address Line 2") ? "" : "Attn:Purchasing Department"; Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.