Find records not linked

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?
 
J

Jeff Boyce

Mark

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query lacks Specific Criteria 1
Help! Need to update linked SQL table in Acc07 3
date query in the sub-report 1
Query in preparation for tabbed form 3
Using Append Queries with Linked Tables 3
Access linking new student form to new course form 2
register student to course 0
Create a Not In query, but show only certain records 3

Top