Undefined function 'IFF' in expression

B

Bill Barber

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
 
F

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
Click to expand...

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.
 
Top