Query Result Incorrect

C

CRBI

I have a query based on a membership table in which I need to pull out all
the people who do not have an email address. When I design the query and put
"is null" in the criteria field for email address, it still returns names
with email addresses. How can I get this query to pull out only the members
who do not have an email address?
 
D

Dorian

Well what do you have in the columns with no email address?
You should have a null but its possible your code puts either an empty
string or a space in there.
Since an email address should contain an '@' character you could try
WHERE NOT LIKE "*@*"
you may have to use % instead of *, can't remember which is correct.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
P

Pendragon

You also have to be sure to repeat any other criteria which may appear on a
different criteria line. For example, if in Membership ID you had <>99 on
one line and <>100 on the second line, having Is Not Null in the email
address criteria on only one line means that is being applied only with the
<>99 criteria. You would need to have Is Not Null also on the same line as
<>100.
 

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

Top