how do i create a selective query in access?

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

Guest

I am trying to create a query that will show a group of people who will teach
at a sunday school or vbs. There are 4 possible positons: teach sunday
school, assist sunday school, teach vbs, and assist vbs. In Query criteria I
have place a "y" in each field but when you run the query only those people
who will do all 4 positions showup. I need to be able to show anyone who will
do 1, 2, 3 or all 4 positions. In Entry form for each position it is either
blank or there is a y indicating they will do this task
 
placing criteria on the same row in a query creates an "AND" condition where
all of them must be true. Place your criteria for each column on a separate
row in your query to create an "OR" statement.
 
Back
Top