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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query to overcome field type problem? 4
Query alternatives 8
Access Query problem 1
Compare results of two expressions within query 1
Problem with Access concatenate query 4
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
SELECT Query Help - Multiple Records 1
Join strings in Query 1

Back
Top