R rbrule Registered User. Local time Today, 18:04 Joined Jan 13, 2004 Messages 108 Aug 20, 2006 #1 Can someone tell me the correct macro condition, item, and expression to populate field # 1 with a word if field # 2 is null and populate field #1 with a different word is field # 2 is not null?
Can someone tell me the correct macro condition, item, and expression to populate field # 1 with a word if field # 2 is null and populate field #1 with a different word is field # 2 is not null?
R RV Registered User. Local time Today, 23:04 Joined Feb 8, 2002 Messages 1,115 Aug 20, 2006 #2 I never do macro's but have a look at the IIF funktion RV