Help needed for nested iif in microsoft access 2010

Hi all,

Current i have 3 table known as

Trainee- nric,name,address
Result- nric,course_code,result
Courses- course_code,count_core,count_elective,core/elective

i link Trainee.nric to Result.nric and Result.course_code to Courses.course_code

i need to show the criteria whereby the trainee must met the condition of completing 3 core module and 3 elective in order to be eligible.

im able to sumup the number by using sum(count_core) and sum(count_elective) to show that the trainee met the 7 core and 3 elective criteria.

Full qualified: IIf([Sumofcount_core]>=5 And [Sumofcount_elective]>=3,"Qualified","not qualified")

however i need to add one more condition because those that take the core/elective might fail and i might be still count them as pass so i need to add in [Result].[Result] = "COMPETENT" in my code

Would appreciate alot if someone could help me in that
Thanks. :)

Help needed for nested iif in microsoft access 2010