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.
 

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

Similar Threads

Counting multiple memberships 1
No results when adding 2nd table to query 1
Help Totaling More Than One Entry 2
Display query results only if field is not null 3
Three fields conditionally based on other fields 6
Split data in field on character return 0
Criteria for an email address fied 2
linked fields in a query 3

Back
Top