Access 97 Query Some data missing in results?

[RedHatter]

I Have written a query to show a list of task that have been completed by a student indenticated by the date perromed and read.. The query should also show the task that have not been completed indicated by no date besdie the the taskname.

When I run the query only some of the tasks not completed are listed.
The list of all tasks are found in the table Stocker (Dos) Tasks under Taskname.
I have used the criteria Is Null under Stocker ( Dos) Class Taskname to show tasks not completed.

Please see the SQL below.
Much help needed here.

Many thanks inadvance .

SELECT [Stocker (Dos) Tasks].StockerTaskName, [Stocker (Dos) Class].[Stocker(Dos)Tasks], [Stocker (Dos) Class].PrdPerformed, DateAdd("m",[Ranking],[PrdPerformed]) AS Recert, [Stocker (Dos) Class].StudentName, [Stocker (Dos) Class].PrdRead
FROM [Stocker (Dos) Class] RIGHT JOIN [Stocker (Dos) Tasks] ON [Stocker (Dos) Class].[Stocker(Dos)Tasks] = [Stocker (Dos) Tasks].StockerTaskName
WHERE ((([Stocker (Dos) Class].StudentName)=[Enter Student Name])) OR ((([Stocker (Dos) Class].[Stocker(Dos)Tasks]) Is Null));

 

[pmanivas]

try putting left join instead of right join
This should work

 

[RedHatter]

Pmanicvas,
I tried your suggestion but when ran the query it return only tasks that were completed but did not return any of the tasks that were not.

Is it possible that the Stocker ( Dos ) Task table is corrupted. I did delete some records from it.
If so how is the best way to identify problems.

Many thanks inadvance again