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
|
|||
|
|||
IF ISNUMBER FIND in query design expression
I use the following formula in Excel and it works...I now want to do this in
a query. Can I add it as an expression in the design grid in a seperate column and how does the syntax change? I will also want to use TRUE/FALSE for the result. =IF(ISNUMBER(FIND("TRANSF",H2)),"*", "") |
#2
|
|||
|
|||
IF ISNUMBER FIND in query design expression
Try this --
My_Output: IIF(InStr([YourFieldName],"TRANSF")0,"*", "") -- Build a little, test a little. "gator" wrote: I use the following formula in Excel and it works...I now want to do this in a query. Can I add it as an expression in the design grid in a seperate column and how does the syntax change? I will also want to use TRUE/FALSE for the result. =IF(ISNUMBER(FIND("TRANSF",H2)),"*", "") |
Thread Tools | |
Display Modes | |
|
|