Link to home
Start Free TrialLog in
Avatar of exp vg
exp vg

asked on

Access IIF IN - Multiple Statements - Formatting Issue

Hello

I have the following IIF statement. If I include just one IIF, this query works. If I include more than one, it does not. Please confirm where the formatting issue is.

Type: IIf([Event] In ("Birthday Party","Sleepover Party","Bake Sale"),"Child Event"),IIF([Event] In ("Movie Theater","Overseas Cruise","Dinner on the Town","Brunch"),"Adult Event")

This was created in notepad as suggested. The first event - child event - works alone. However when I add the second event - adult event - I get an error that I need to include quotations. I have reviewed the quotes, and all seems to be in order.

Thank you
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of exp vg
exp vg

ASKER

Finally got this to work. Thank you everyone.
Avatar of exp vg

ASKER

Thank you everyone.