Not Null, Not Empty but it has nothing in it...

[Guru2B]

Hi,

I am trying to create a query that returns only records that have an email address.

The SQL looks like this..

SELECT * FROM

WHERE EMail <> null (or empty or whatever)

I've tried everything it seems (except of course the right thing) and cannot get it to work. Any ideas? I am using Access with VB and DAO

Thanks.

 

[jjames]

SELECT * FROM

WHERE EMail Is Null

 

[jjames]

or..

SELECT * FROM

WHERE NOT (EMail Is Null)