multi yes query

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

Guest

I have two tables. One that has fields for courses with a description field
and a passed yes/no field. I have a table for employees names etc... I need
to find employees that have taken both an excel class and an access class and
passed the courses.

I created a query that said find any *access* class and yes for passed. The
second row for my or part was find any *excel* class and yes for passed. So
it shows me anyone who took an excel or access class and passed it. Now I
want it to say show me only those people that took any excel and any access
and passed the class.
 
Answered in your posting in this forum
Subject: query yes for two fields
Date: Tue, 21 Feb 2006 07:26:28 -0800
 
Back
Top