Prev: Not in List Code
Next: Using emails addresses in access to send a mass email to
From: Colin Weir on 10 Feb 2010 06:30
Hi there

I'm trying to do something I think would be simple however I am
toiling with it.

I have a database and I've created a query to get it to list all the
records of people's email address along with their names and also
whether they have been archived or not.

I would like it to only show the information where there is an email
address entered and not all the blank ones also.

Design view is set as follows

Forename
Surname
Archive: No
Archive Date: Is Null
email_address

I've tried using * and Is Not Null but I am still getting all the
records showing.

Thanks

Colin
From: Arvin Meyer [MVP] on 10 Feb 2010 09:53
For the address list you are looking for, use only the addresses, not every
field. Also use the DISTINCT keyword to eliminate duplicates:

SELECT DISTINCT tblMyData.EmailAddress
FROM tblMyData
WHERE (((tblMyData.EmailAddress) Is Not Null));
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Colin Weir" <colin.weir(a)blueyonder.co.uk> wrote in message
news:9f418fc1-490e-45f9-be8d-88c40b0b1773(a)j31g2000yqa.googlegroups.com...
> Hi there
>
> I'm trying to do something I think would be simple however I am
> toiling with it.
>
> I have a database and I've created a query to get it to list all the
> records of people's email address along with their names and also
> whether they have been archived or not.
>
> I would like it to only show the information where there is an email
> address entered and not all the blank ones also.
>
> Design view is set as follows
>
> Forename
> Surname
> Archive: No
> Archive Date: Is Null
> email_address
>
> I've tried using * and Is Not Null but I am still getting all the
> records showing.
>
> Thanks
>
> Colin


 | 
Pages: 1
Prev: Not in List Code
Next: Using emails addresses in access to send a mass email to