Link to home
Create AccountLog in
Avatar of pdvsa
pdvsaFlag for United States of America

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].[LCType] Like "Export*","Export/Import LC's","Guarantees / SB LC's")

Here is what I attempted but get the syntax ON THE ^^^^^:
MyGroup: IIf([tblLCTypeDropBox].[LCType] Like "Export*" OR LIKE "IMPORT*","Export/Import LC's","Guarantees / SB LC's")                                            ^^^^^^^^^^^^^^^^^^^

tHANK YOU
ASKER CERTIFIED SOLUTION
Avatar of Cluskitt
Cluskitt
Flag of Portugal image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Iif(Left([tblLCTypeDropBox].[LCType],6) In ("Export","Import"), "Export/Import LC's","Guarantees / SB LC's")