G
Guest
I am trying to make an IIF statement work properly in a Query.
In my mind I want it to do this:
IIF(IsNull([Forms]![myForm]![Field1])=True,Like "*",Between
[Forms]![myForm]![Field1] AND [Forms]![myForm]![Field2])
Saying that if Field1 is Null I want ALL and if not null then I want
Between. But this statement does not work.
I appreciate your help on this.
Thank you.
Steven
In my mind I want it to do this:
IIF(IsNull([Forms]![myForm]![Field1])=True,Like "*",Between
[Forms]![myForm]![Field1] AND [Forms]![myForm]![Field2])
Saying that if Field1 is Null I want ALL and if not null then I want
Between. But this statement does not work.
I appreciate your help on this.
Thank you.
Steven