Undefined function 'IFF' in expression

[Guest]

I have absolutely no idea what syntax the following instruction is looking for.

Any assistance will be greatly appreciated.

Statement below is in the Criteria Cell of a query.

(SELECT * FROM DACSSTbA WHERE TextA Like
IFF(Forms![TestForm]![TextA]="Z","*",Forms!TestForm!TextA))

Thank You

Bill

 

[Allen Browne]

The Immediate If function is:
IIf()

 

[fredg]

I have absolutely no idea what syntax the following instruction is looking for.

Any assistance will be greatly appreciated.

Statement below is in the Criteria Cell of a query.

(SELECT * FROM DACSSTbA WHERE Text Like
IFF(Forms![TestForm]![TextA]="Z","*",ForA ms!TestForm!TextA))

Thank You

Bill

1) The correct function name is IIf not IFF.
IIf(forms...etc.)

In the Criteria grid write:
Like IIF(Forms![TestForm]![TextA]="Z","*",Forms!TestForm!TextA))

The (SELECT * FROM DACSSTbA WHERE Text is what is shown in the SQL
view, not in the QBE grid.