Can anyone tell me what I'm doing wrong with this statement:
Location: (IIf([ResidentialAddressCountry]=("") Or IsNull([ResidentialAddressCountry]),"A" & [HomePOCode],"X" & [ResidentialAddressCountry]))
It works if ResidentialAddressCountry is empty, but the else section doesn't work - just gives me #Error
Location: (IIf([ResidentialAddressCountry]=("") Or IsNull([ResidentialAddressCountry]),"A" & [HomePOCode],"X" & [ResidentialAddressCountry]))
It works if ResidentialAddressCountry is empty, but the else section doesn't work - just gives me #Error