Can you combine the fields?

If you're using SQL to write your queries or recordsource, you could use a statement like this:
Select * from MyTable where [field1] & " " & [field2] & " " & [field3] like '*MyCriteria*'

If you're using the query grid, you can do the same thing by using the Build tool and selecting all your fields. In your grid, the field would read:
CombineFields: [field1] & " " & [field2] & " " & [field3]
and the criteria field would read:
Like "*mycritera*"

Hope it helps....

jct

[This message has been edited by jct (edited 01-10-2000).]