I have a database containing students from Grade 8 to 12.
Each Grade can have several classes so Grade 12 could be 12A, 12B, 12C etc.
I have a form with a Check Box (CheckGrade12) that should determine if a query selects all students or just Grade 12 students.
If I use the expression below as criteria in the query it works as expected selecting students from 12H or 12G
IIf([Forms]![Report]![CheckGrade12]=True,"12H","12G")
But when I use the Like operator to select all students or just Grade 12 students in the criteria as below nothing is selected.
IIf([Forms]![Report]![CheckGrade12]=True, Like "12*", Like "*")
Any Ideas where I am going wrong?