Query Not In

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi,
I developed an Access 2000 application, to track
employee training record.
Now I need a query to find out who hasn't attend an
training class?
I created two queries, the 1st one will query who has
attend the training class, and in the 2nd query, for the
employee_no criteria, I put a SQL statement as:
Not In (select Employee_no from 1stQuery). This is working
but the perfermence was very bad. Since the employee no
from the 1st query could be couple thousands.
Any idea a better way to run the query? Thanks in
advance.
 
Hi,


Run the query wizard about finding the unmatched record: an employee
won't be matched in any record of the training class table.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top