A
Amer
Hi
I created a totals query to get the final status report of students based on
calculating attendance rate and test result.
I added the followinf condition using IIF:
Status: IIf([AttendanceRate]<69 And [Result]="Passed";"Qualified";"Pending")
So, the query should show "Qualified" if both arguments are true when the
attendance rate is greater than 69 and the result equals "Passed".
However, the query shows "Pending" only if the result does not equal "Passed".
I created a totals query to get the final status report of students based on
calculating attendance rate and test result.
I added the followinf condition using IIF:
Status: IIf([AttendanceRate]<69 And [Result]="Passed";"Qualified";"Pending")
So, the query should show "Qualified" if both arguments are true when the
attendance rate is greater than 69 and the result equals "Passed".
However, the query shows "Pending" only if the result does not equal "Passed".