Jun 15, 2007 #1 dwesnyc Technical User Nov 24, 2006 14 US 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.
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.
Jun 15, 2007 2 #2 PHV MIS Nov 8, 2002 53,708 FR IIf([column] Like 'bo*','bob',[column]) Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Jun 15, 2007 Thread starter #3 dwesnyc Technical User Nov 24, 2006 14 US 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 Upvote 0 Downvote
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
Jun 15, 2007 #4 PHV MIS Nov 8, 2002 53,708 FR IIf([column] Like 'bo*','bob',IIf([column] Like 'dav*','david',[column])) Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
IIf([column] Like 'bo*','bob',IIf([column] Like 'dav*','david',[column])) Hope This Helps, PH. FAQ219-2884 FAQ181-2886