Query Result Incorrect

  • Thread starter Thread starter CRBI
  • Start date Start date
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?
 
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".
 
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.
 
Back
Top