Using a field as criteria

[Val]

Hi there,

I am tring to query a set of data but exclude any lines
that have the same information as another table.

Example:
Say I have a list of social security numbers of everyone
in my company and I am looking to leaveout anyone who's
social security number is ina a bad employee table how do
I get the query to have a negitive relationship or use
that field in the second table as criteria?

 

[Allen Browne]

There is an Unmatched Query wizard that can give you this result.

Basically, you end up with an outer join (double-click the line joining the
2 tables in query design), where the related table's foreign key is null
(i.e. it doesn't match anything).