If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IIF function help in query
Hello,
I have the following field in the query to look at a field PartDesc, if any of the text have a *BUSH* word, return yes, otherwise no. BUSH: IIF(PartDesc= Like *BUSH*, "yes","no") Why the Like *BUSH* not working? Thanks |
#2
|
|||
|
|||
IIF function help in query
Because = and LIKE are two operators, a little bit like:
4 * / 3 would mean what (multiply followed by divide)? Probably better to remove the =, in this case: BUSH: IIF(PartDesc Like *BUSH*, "yes","no") Vanderghast, Access MVP "Cam" wrote in message ... Hello, I have the following field in the query to look at a field PartDesc, if any of the text have a *BUSH* word, return yes, otherwise no. BUSH: IIF(PartDesc= Like *BUSH*, "yes","no") Why the Like *BUSH* not working? Thanks |
#3
|
|||
|
|||
IIF function help in query
Try using the below:
BUSH: IIf([PartDesc] ALike "%BUSCH%","yes","no") -- Rick "Cam" wrote: Hello, I have the following field in the query to look at a field PartDesc, if any of the text have a *BUSH* word, return yes, otherwise no. BUSH: IIF(PartDesc= Like *BUSH*, "yes","no") Why the Like *BUSH* not working? Thanks |
#4
|
|||
|
|||
IIF function help in query
On Thu, 13 May 2010 07:00:01 -0700, Cam wrote:
Hello, I have the following field in the query to look at a field PartDesc, if any of the text have a *BUSH* word, return yes, otherwise no. BUSH: IIF(PartDesc= Like *BUSH*, "yes","no") Why the Like *BUSH* not working? Thanks You cannot use = Like. Use either = or Like. You also need to enclose the criteria value within quotes. BUSH: IIF(PartDesc Like "*BUSH*", "yes","no") The above should fine all records that contain the letters "BUSH" anywhere in the field, i.e. "Bush", "Bushmill", etc. if you wish just the word "Bush" to be returned, use Like "* Bush *" -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|