Help with a simple query

Bursal

Registered User.
Local time
Today, 13:26
Joined
Aug 26, 2012
Messages
25
I am sure there is an extremely simple solution to this question. I have started a contacts database for a community organisation that I belong to. I am having trouble working out how to do a query that will return a list of contacts that don’t have email addresses so that I can create postal mail merge query. The fields I have in the query are FirstName, LastName, Address1, Address2, Suburb, PostCode and email.
Thanks in advance.
Di
 
As a start :
Code:
SELECT 
	ID, 
	FirstName, 
	Email
FROM 
	Table1
WHERE 
	Email Is Null;

Thanks
 

Users who are viewing this thread

Back
Top Bottom