if statement with multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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")
 
Back
Top