IF ISNUMBER FIND in query design expression

G

gator

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)),"*", "")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bug? Using full identity expression in any arbitrary column works 4
Use In() Expression as Query criteria with guts from Function 1
Query design view - commas being changed to pipe characters 4
Use result of expression in another expression?? 9
Help with ISNUMBER formula 2
If, And, Isnumber statement 5
IF (ISNUMBER formula with a Range 1
Nested If in Query 4

Top