IIf Function in query criteria (1 Viewer)

Sarah.M

Member
Local time
Today, 15:55
Joined
Oct 28, 2021
Messages
335
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

..forever waiting... waiting for jellybean!
Local time
Today, 20:55
Joined
May 7, 2009
Messages
19,175
use the IF...Else...End If macro.
 

Sarah.M

Member
Local time
Today, 15:55
Joined
Oct 28, 2021
Messages
335
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

..forever waiting... waiting for jellybean!
Local time
Today, 20:55
Joined
May 7, 2009
Messages
19,175
i thought you need a macro.
try this:
Criteria: IIF([somValue] = False, [theFieldNameToFilter], [someValue])
 

Users who are viewing this thread

Top Bottom