Queries to sort correct Mail and Email

  • Thread starter Thread starter Melon via AccessMonster.com
  • Start date Start date
M

Melon via AccessMonster.com

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
 
Nevermind. Like a fool, I had an extra space in the Personal Email field name.
Thanks
 
Back
Top