IIf Function in query criteria

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
IIf ( expr , truepart , falsepart )
I want to say if the condition is False do nothing don't filter?

please help

 

[arnelgp]

use the IF...Else...End If macro.

 

[Sarah.M]

use the IF...Else...End If macro.

I mean with query criteria iif it is false do nothing
Kindly can you clarify more
Do you mean you want to connect macro with query criteria? How

 

[arnelgp]

i thought you need a macro.
try this:
Criteria: IIF([somValue] = False, [theFieldNameToFilter], [someValue])

 

[Sarah.M]

i thought you need a macro.
try this:
Criteria: IIF([somValue] = False, [theFieldNameToFilter], [someValue])

I will try it and get back to you
Thanks!