A awake2424 Registered User. Local time Today, 11:41 Joined Oct 31, 2007 Messages 479 Oct 15, 2013 #1 What is the correct syntax of and OR statement in a query? IIf([Color)="Blue or Green","group is 1". Thank you.
What is the correct syntax of and OR statement in a query? IIf([Color)="Blue or Green","group is 1". Thank you.
pr2-eugin Super Moderator Local time Today, 17:41 Joined Nov 30, 2011 Messages 8,487 Oct 15, 2013 #2 It should be.. Code: IIf([Color] = "Blue"[COLOR=Red][B] Or [Color] = "Green"[/B][/COLOR], "Group is 1", "False part Not defined")
It should be.. Code: IIf([Color] = "Blue"[COLOR=Red][B] Or [Color] = "Green"[/B][/COLOR], "Group is 1", "False part Not defined")
