microsoft+access+training+course - Access

You may want to try a Like query entering

Like "*" & [Enter Match] & "*"

in the condition line of the fields you want to search

This will search across as many fields as you type the code into on the query for the values that you enter in the [Enter Match] peramiter

Graeme.