Showing information in report if a certain condition is met

P

ProgrammerBob

I have a report where a school department has a series of required and
not required courses. Basically I have a report that looks like this

Student #1
____________________
LAI514|FA03|A+
CEP506|Not taken yet
LAI574|SP03|B+
..
..
Student #2
____________________
LAI514|FA02|C-
CEP506|Not taken yet
LAI574|Not taken yet
etc

I am querying the complete list of students, so basically I want to
check if this course for this one person exists in the list, and if it
does print out the grade and semester that it was taken, otherwise
print out nothing for semester or grade.

Thanks
 
J

Jeff Boyce

Without some idea of your underlying data structure, it will be tough to
explain any specifics.

In general, you can join your students table to your studentscourses table
with a "left" (or right) join, then display all students. You can add a
field that displays either the grade (if it exists) or your expression ("Not
yet taken"). You'd use the IIF() function to determine which.
 
Top