Unmatched query

[news]

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

 

[[MVP] S.Clark]

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.

 

[Herman]

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

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

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