Syntax Help

[dawnd3]

Can you help me?

What is wrong with this syntax? I keep getting "wrong number of arguments"

Thanks

(this is in the update field of an update query)

IIf(IsNull([tblNewData].[Business E-mail Address])) And IIf(IsNull([tblNewData].[Home E-mail])),[MemberInfo].[PrimaryEmail],IIf([tblNewData].[E-mail Preference]="Business"),[Business E-mail],IIf([tblNewData].[E-mail Preference]="Home"),[Home E-mail],[MemberInfo].[PrimaryEmail]))

http://www.calliopeconsulting.net

 

[dawnd3]

Never mind, figured it out

IIf(IsNull([tblNewData].[Business E-mail Address]) And IsNull([tblNewData].[Home E-mail]),[MemberInfo].[PrimaryEmail],IIf([tblNewData].[E-mail Preference]="Business",[Business E-mail],IIf([tblNewData].[E-mail Preference]="Home",[Home E-mail],[MemberInfo].[PrimaryEmail])))

http://www.calliopeconsulting.net