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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
try:
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") )
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") )
you have closing parenthesis at the wrong place (after "Child event"), it should be at the end of te statement.
copy and paste this
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",""))
copy and paste this
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",""))
You have also not included a final false path but Rey's solution addresses that by returning an empty string. An alternative is to give it a value.
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","Event Not Found"))
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","Event Not Found"))
Premium Content
You need an Expert Office subscription to comment.Start Free Trial