SQL, expression, code or anything help

[ccchan]

I have a query that displays the following:



I want to generate a report that will display the list of names and year level of the students who has a "PASS" remark. If the student has a "FAIL" remark in any subject, his/her name will not be included in the report.

How can I do this?

Thank you!

[trevor40]

fastest way would be to make a report using the access report wizard, then go into the report properties and edit the record source.

Edit the query the report is based on to - Example Only! not tested, your fields may be different.
SELECT [student_list].*
FROM [student_list]
WHERE ((([student_list].[expr2])="pass"));
or
SELECT [student_list].*
FROM [student_list]
WHERE ((([student_list].[expr2])<>"fail"));

[ccchan]

Hi there. I tried the sql statement you posted but it returned the names of the student with a FAIL remark.

[ccchan]

I tried this statement but this returned the names with the "FAIL" remark.

[ccchan]

fastest way would be to make a report using the access report wizard, then go into the report properties and edit the record source.

Edit the query the report is based on to - Example Only! not tested, your fields may be different.
SELECT [student_list].*
FROM [student_list]
WHERE ((([student_list].[expr2])="pass"));
or
SELECT [student_list].*
FROM [student_list]
WHERE ((([student_list].[expr2])<>"fail"));

Also, when i open the query it says that there is a circular reference.