3 fields in tblMembers are HomeEmail, BusinessEmail, and UseForEmail ... all are text, with "Allow Zero Length" = No.
In a query, I want a column which pulls the one to use. My IIf function is
The function produces inconsistent results, sometimes showing but other times not. Always showing if both HomeEmail and BusinessEMail have values. In all but 2 cases in the database there is a value in either Home or Business Email.
If I change the function like this
I get more results because there are more members who have a Home E-Mail address.
What do I have to fix in order to produce a value in all but the 2 instances where the member has neither Home nor Business E-mail?
Tom
In a query, I want a column which pulls the one to use. My IIf function is
Code:
E-Mail: IIf([UseForEmail]=[BusinessEmail],[BusinessEmail],[HomeEmail])The function produces inconsistent results, sometimes showing but other times not. Always showing if both HomeEmail and BusinessEMail have values. In all but 2 cases in the database there is a value in either Home or Business Email.
If I change the function like this
Code:
E-Mail: IIf([UseForEmail]=[HomeEmail],[HomeEmail],[BusinessEmail])What do I have to fix in order to produce a value in all but the 2 instances where the member has neither Home nor Business E-mail?
Tom
