pdvsa
asked on
Grouping and iif
Experts, I am modifying my grouping in the report. I have added the like statement. I need to add an additional like statement such as "Or" but I get a syntax.
here it is now...I need to add another like "Import LC*" but get a syntax.
MyGroup: IIf([tblLCTypeDropBox].[LC Type] Like "Export*","Export/Import LC's","Guarantees / SB LC's")
Here is what I attempted but get the syntax ON THE ^^^^^:
MyGroup: IIf([tblLCTypeDropBox].[LC Type] Like "Export*" OR LIKE "IMPORT*","Export/Import LC's","Guarantees / SB LC's") ^^^^^^^^^^^^^^^^^^^
tHANK YOU
here it is now...I need to add another like "Import LC*" but get a syntax.
MyGroup: IIf([tblLCTypeDropBox].[LC
Here is what I attempted but get the syntax ON THE ^^^^^:
MyGroup: IIf([tblLCTypeDropBox].[LC
tHANK YOU
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Iif(Left([tblLCTypeDropBox ].[LCType] ,6) In ("Export","Import"), "Export/Import LC's","Guarantees / SB LC's")