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
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. :)
