if function

[pal]

hello

i want to write if condition in query that use to

if the grades of the student A or B+ or B or C+ or C or D+ or D
then the completed hours = sum of the course hours


OR in other mean if grade Not = "F" then
completed hours = sum of the course hours

anyone that can help me to write the expression using if function????

Best regards,

 

[pbaldy]

This type of thing?

IIf(Grade = "F", 0, SumOfCourseHours)