Problem using Like operator inside IIF Function

[mikehZA]

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?

[orange]

See this for details on IIF

[ranman256]

dont use it that way, instead use the
query1 : [Forms]![Report]![CheckGrade12]=True
query2 : [Forms]![Report]![CheckGrade12]=false

put the 2 queries in 1 UNION query. No IIF needed.

[CJ_London]

sounds like you are trying to apply this as a query criteria - if so, then you cannot do it this way.

instead try this mockup of query grid - change names to suit

Field:___GRADE____[Forms]![Report]![CheckGrade12
Table:__tblGrades
Sort:
Show: X
Criteria:_Like "12*"______True
or:___________________False