3 fields

[superrob5]

is there a way to run a query that will search in 3 fields and will look to see "Em*" is located in any of them.

I know in the query you can and criteria and an or to that criterial

but I want it to look in any of those 3 fields and if the word "Em*" is there I want to see it.

Rob

 

[FoFa]

Put LIKE "Em*" in each column criteria make sure you use the OR option between the fields. If you have a large table, this may run poorly.