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 "Mark" wrote in message news:5f20c8ee-252d-405f-b083-e3e0818f3710@d45g2000hsc.googlegroups.com... > 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?
On 25 Aug, 17:56, "Jeff Boyce" wrote: > Mark > > The query wizard in Access has a "unmatched" query. > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "Mark" wrote in message > > news:5f20c8ee-252d-405f-b083-e3e0818f3710@d45g2000hsc.googlegroups.com... > > > > > 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?- Hide quoted text - > > - Show quoted text - Thanks for the quick response
