IIf statements in queries

[rodmane]

I am trying to write an IIf statement in the criteria section of a field, the statement is:

IIf([Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0]="All",?,[Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0]")

Basically it takes the value selected in the combo box of a form and filters that name from the query and creates a table. I want the IIf statement to select all records if the value selected in the combo box is "All" and to select specific records if any other value is selected in the combo box. Thank you for the help.

 

[smozgur]

Actually I would use form filter for this but here is your corrected criteria.

IIf([Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0]="All","",[Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0])

I hope it helps.
Suat

 

[rodmane]

I actually tried the following and it worked: Like IIf([Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0]="All","*",[Forms]![FRM: Import FN1 Extract - Manager Specific]![Combo0]")

The problem with the middle term was that the IIf statement was not letting the criteria just be the text so I added the I statement. Thanks!!