if statement with multiple values

O

OUPioneer

Hi all,
Im trying to figure out how write an if statement in access with multiple
values, but not a nested if statement.... im famliar how this is written in
Cognos:
if ('column name' in(value,value,value..etc)) then (value) else (value)

im not sure how this kind of function can be written in Access??? anyone
have an example or a good link on how to write if statements?

thanks!
 
F

fredg

Hi all,
Im trying to figure out how write an if statement in access with multiple
values, but not a nested if statement.... im famliar how this is written in
Cognos:
if ('column name' in(value,value,value..etc)) then (value) else (value)

im not sure how this kind of function can be written in Access??? anyone
have an example or a good link on how to write if statements?

thanks!
Click to expand...

Exp: IIf([LastName] In ("Smith","Jones","Green"),"Yes","No")
 
Top