IIF Statement Access Report

February 17, 2009 at 17:15:41
Specs: Windows XP
I have to enter an IIF statement where students earning the passing grades of A B or C get a comment of "Good Job! and students earning the grade of R receive a comment "Student needs to re-enroll". How would I write this IIF statement. I have tried this one, but it is coming back with all students receivng the comment "Students need to re-enroll.

=IIf([Grade]="A" And [Grade]="B" And [Grade]="C","Good Job!","Students need to re-enroll")

See More: IIF Statement Access Report

Report •

February 17, 2009 at 17:47:55
I doubt a student can get an A AND a B AND a C.

I'm guessing they could get an A OR a B OR a C.

Report •
Related Solutions

Ask Question