Find records not linked

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I would like to create a query which only shows records that are not
are linked. In this example I have a host table, a student table and
a table to link students to the host. Basically I would like to show
all the students who have not been linked to a host.

Any suggestions?
 
Mark

The query wizard in Access has a "unmatched" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top