A
Archer
I am trying to include the following condition in the control source of a label
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€))+
IIf([Number of Courses]>=2 ,IFF([Course 2 Enrolled?] = “Noâ€,â€Course 2â€))
+IIf([Number of Courses]>=3 ,IFF([Course 3 Enrolled?] = “Noâ€,â€Course3â€))
and I get an Syntax Error.
I tried the following variations and these are the results i got
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€))
Result: Syntax Error
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€,
""),"")
Result: Syntax Error
=IIf([Number of Courses]>=1 And [Course 1 Enrolled?] = “Noâ€,â€Course1â€)
Result: Syntax Error
=IIf([Number of Courses]>=1 And [Course 1 Enrolled?] = “Noâ€,â€Course1â€,""),"")
Result: Syntax Error
Can anyone help out?
[Number of Courses] is a field from Table Courses
[Course 1 Enrolled] is a field from another Table Student
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€))+
IIf([Number of Courses]>=2 ,IFF([Course 2 Enrolled?] = “Noâ€,â€Course 2â€))
+IIf([Number of Courses]>=3 ,IFF([Course 3 Enrolled?] = “Noâ€,â€Course3â€))
and I get an Syntax Error.
I tried the following variations and these are the results i got
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€))
Result: Syntax Error
=IIf([Number of Courses]>=1 ,IFF([Course 1 Enrolled?] = “Noâ€,â€Course1â€,
""),"")
Result: Syntax Error
=IIf([Number of Courses]>=1 And [Course 1 Enrolled?] = “Noâ€,â€Course1â€)
Result: Syntax Error
=IIf([Number of Courses]>=1 And [Course 1 Enrolled?] = “Noâ€,â€Course1â€,""),"")
Result: Syntax Error
Can anyone help out?
[Number of Courses] is a field from Table Courses
[Course 1 Enrolled] is a field from another Table Student