Unmatched query
in [Queries]
|
From: news on 24 Feb 2005 12:44 Hello I created a unmached query where i want to see the students who not made a specific task. for example in grupo 5-1 I have 19 students, 4 students made the task nieuw. What I want to see is a list of students who did not make the task. The query is: SELECT tareas.Grupo, tareas.Nombre, tareas.ApellidoP, tareas.ApellidoM, tareas.tarea FROM tareas LEFT JOIN [tareas estudiantes] ON tareas.IDtarea = [tareas estudiantes].IDtarea WHERE (((tareas.Grupo)="5-1") AND ((tareas.tarea)="nieuw") AND (([tareas estudiantes].IDtarea) Is Null)); The result of the query I have now not show this what do I wrong? Hope someone can help me. Herman
From: [MVP] S.Clark on 24 Feb 2005 16:33 Typically, adding criteria to an Outer Join will make the query behave like an Inner Join. Try breaking the query into two. One to house the criteria, the other to handle the Outer Join. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "news" <hermienospam(a)coqui.net> wrote in message news:ee98$421e12b7$40ed8057$4847(a)COQUI.NET... > Hello > > I created a unmached query where i want to see the students who not made a > specific task. > > for example in grupo 5-1 I have 19 students, 4 students made the task > nieuw. > What I want to see is a list of students who did not make the task. > > The query is: > > SELECT tareas.Grupo, tareas.Nombre, tareas.ApellidoP, tareas.ApellidoM, > tareas.tarea > FROM tareas LEFT JOIN [tareas estudiantes] ON tareas.IDtarea = [tareas > estudiantes].IDtarea > WHERE (((tareas.Grupo)="5-1") AND ((tareas.tarea)="nieuw") AND (([tareas > estudiantes].IDtarea) Is Null)); > > The result of the query I have now not show this what do I wrong? > Hope someone can help me. > > Herman > >
From: Herman on 25 Feb 2005 08:23 Hello S.Clark I did your recomendation and made a query which hold the criteria. From that query I made and unmatched query. But still not see the task not made by a students Query is now: SELECT tareas.ss, tareas.Grupo, tareas.Nombre, tareas.ApellidoP, tareas.ApellidoM, tareas.IDtarea, tareas.tarea FROM tareas WHERE (((tareas.Grupo)="5-1") AND ((tareas.tarea)="nieuws")); The SQL of the unmatched query is: SELECT Tareasnew.ss, Tareasnew.Grupo, Tareasnew.Nombre, Tareasnew.IDtarea, Tareasnew.tarea FROM Tareasnew LEFT JOIN [tareas estudiantes] ON Tareasnew.IDtarea = [tareas estudiantes].IDtarea WHERE ((([tareas estudiantes].IDtarea) Is Null)); This query still shows no records of studnets who not did made the task? Please look at the design and inform what is wrong? Herman "[MVP] S.Clark" <steve.clark_NOSPAM(a)FMSInc.com> wrote in message news:%23S7OEirGFHA.3968(a)TK2MSFTNGP14.phx.gbl... > Typically, adding criteria to an Outer Join will make the query behave like > an Inner Join. Try breaking the query into two. One to house the criteria, > the other to handle the Outer Join. > > -- > Steve Clark, Access MVP > FMS, Inc. > www.fmsinc.com/consulting > > > "news" <hermienospam(a)coqui.net> wrote in message > news:ee98$421e12b7$40ed8057$4847(a)COQUI.NET... > > Hello > > > > I created a unmached query where i want to see the students who not made a > > specific task. > > > > for example in grupo 5-1 I have 19 students, 4 students made the task > > nieuw. > > What I want to see is a list of students who did not make the task. > > > > The query is: > > > > SELECT tareas.Grupo, tareas.Nombre, tareas.ApellidoP, tareas.ApellidoM, > > tareas.tarea > > FROM tareas LEFT JOIN [tareas estudiantes] ON tareas.IDtarea = [tareas > > estudiantes].IDtarea > > WHERE (((tareas.Grupo)="5-1") AND ((tareas.tarea)="nieuw") AND (([tareas > > estudiantes].IDtarea) Is Null)); > > > > The result of the query I have now not show this what do I wrong? > > Hope someone can help me. > > > > Herman > > > > > >
|
Pages: 1 Prev: How do I calculate percentile in acccess? Next: Fixed vs. Relative Time Periods |