Either or in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table for a membership organization. It includes prospects and
those prospects that have become members.

The "became member" field is a yes/no.
The "no" field is a yes/no.
There is a "probability" field that is numeric.
Prospects who have not been connected with yet have nothing in any of the
above fields.

I want to run a query to discover who has been contacted and who have become
members or who have said no or who have a probability entered for potential.

I'm stuck! Help!
 
If you look at the design view of the query you will notice you have another
line under the criteria and it says "OR". On the Criteria line of the query
enter "Yes" in the "Became Member" column and in the "or" row enter "yes" in
the "Yes/No" column.
 
Back
Top