Query Question

[Guest_imported]

I have created a query for a membership database. The query should select records based on the following criteria:

Field Criteria
Email is not null
city Calgary
Catagory not for profit

or
email2 is not null


The first 3 criteria seem to be working properly but the catagory criteria gives me the not for profit and also includes some other catagory records not requested. It does not include all records for the other catagories just some of them. Can someone please tell me what I'm doing wrong.

 

[RickSpr]

Since you said "or" email2 is not null, any row with a null email2 will be selected, regardless of the category, city, or email fields. Does that explain it? Rick Sprague

 

[RickSpr]

Thinking again, you probably wanted this logical expression:
(email is not null or email2 is not null) and city = 'Calgary' and category = 'Not for profit' - right?

In that case, you should duplicate the city and category criteria on the "or" line. The way it works is, each criteria line is evaluated independently. If the criteria on any criteria line is met, the row is selected. Rick Sprague