using an iff stament in my query 2

[dwesnyc]

Hi,

I have a table that has one column with values like bob 1, bob 2, bob 3 etc.

I want to make a query and for anything that is bo* I want it to just display "bob"

I put iff([column]=bo*,"bob") but that did not work. What did I do wrong.

 

[PHV]

IIf([column] Like 'bo*','bob',[column])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dwesnyc]

That worked! But now I want to do another one in the same line, so for instance now I want to add that if its dav* show "david"

how do you combine multiple iif's

 

[PHV]

IIf([column] Like 'bo*','bob',IIf([column] Like 'dav*','david',[column]))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886