delete

[steelcurtain11]

please delete

[June7]

1. Take heed of the hint provided in the question. Use Faculty, Faculty_Classes, Courses tables. Compare the FacDept value with CourseNo. Can use LIKE and wildcard as additional filter criteria in the query. Put the three OR criteria you already have within parenthesis then: AND Not CourseNo LIKE FacDept & "*". Probably don't need the Departments table.

2. You can either reverse calculate the letters to number values with an expression in query or textbox or you can include the GradeValues table in query so the related number field is available.