Query multiple columns with one parameter

J

JayJay

Is it possible to search one text string from multiple columns?

e.g. I would like to search my initials from all the columns in
one table.

Best Regards Jay
 
R

Rick B

sure. In the criteria for each column, put something like...

Like "*" & [enter search string] & "*"

Put this on a separate LINE under each column. placing it on the same line
would create an "AND" statement and would only return results where every
column contains your string. Placing the criteria on separate lines creates
an "OR" statement.

Hope that helps,

Rick B
 
Top