Query, VERY EASY QUESTION, I think

[GiSharp]

Hello,
Can someone please help explain something which I probably "learned" in my one-day, basic ACCESS course but have forgotten, namely:

I have a database (access table) in which I store e-mailadresses in two columns. One column is for general e-mail adresses, and ne column is for direct, "personal" e-mai ladresses.
For some contacts I have only a general e-mailadress and for others I have only a direct e-mail adress.


I would like to make a query with just ONE column for e-mail addresses in which priority is given to direct e-mail adresses. I would like to make a query in which just ONE e-mail address occurs, PREFERABLY the direct e-mail address, but where there is no direct e-mail address, the general e-mail address will show.
I get the feeling this is a really basic, elementary problem. Can anyone hlp, Please?
THANK YOU?
Signed,
Eternally Grateful

[10 Gauge]

You could use an expression in your query such as the following:

SELECT IIf(IsNull([PersonalEmail])=True,[GeneralEmail],[PersonalEmail]) AS Email
FROM tblEmail;

Hope this helps!

Edit: I added what this would look like in Design View opposed to SQL view as well just for your future reference.

[GiSharp]

Thanks a lot 10 Gauge, this did not seem to help, though, sigh. I will pull out my manual I guess...

[10 Gauge]

Let me know what you don't understand and I can try and help you through it because this expression will do exactly what you are trying to accomplish.

I have attached a sample DB for you to look at.