Hi all...
When I run this query,
Expr1: IIf([EmailTo]=1,[Work Email],[Personal Email])
I am prompted to 'Enter Personal Email' and it returns just the work emails.
I have a similar query for Mailing addresses, Work/Home, that runs just fine.
I did change the name of Personal Email, from Home Email, but I have updated
it wherever it counts. Any suggestions?
Thanks
Melon - 31 May 2006 20:55 GMT
Nevermind. Like a fool, I had an extra space in the Personal Email field name.
Thanks