Thread: IF ISNUMBER FIND in query design expression
View Single Post
  #1  
Old May 27th, 2010, 10:14 PM posted to microsoft.public.access.queries
gator
external usenet poster
  
Posts: 166
Default 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)),"*", "")