Query problem

[Guest]

Hi,
I have two table for employees
Table 1 for all employees(ID# , Name)
Table 2 for employees who made the survey(ID# , name)
What I want to do is showing the employees who do not make the survey
Can any body tell me how?

 

[Guest]

First, you shouldn't save the employee name again in the survey table, you
should store the employee Id and retrieve the name from the employee table,
using the ID

To get all the employees that are not in the survey table, use the query
wizard to create UnMatch record query, that list all the records that in one
table but not in the other.

 

[Guest]

thanks, it works

First, you shouldn't save the employee name again in the survey table, you
should store the employee Id and retrieve the name from the employee table,
using the ID

To get all the employees that are not in the survey table, use the query
wizard to create UnMatch record query, that list all the records that in one
table but not in the other.