How do I find all the fields which contain a String??

[RickNiceButThick]

Hi!! I dont use Access very often, but I need to make a DB for school. I need to know how to make a query find all the fields which contain a string, like Instr in VB. For example, say i had a field called "Name", and i had the folowing records:

Dorris
Norris
Norman
John
Bill

I want to be able to put in "orris", and it returns Dorris and Norris, or "o" and it returns Dorris, Norris, Norman, and John.

Can anybody help me????

 

[RickNiceButThick]

Never mind!! Ive worked it out!!!

 

[Computethis]

You can use the "Like" command in the query and create a litle pop up window to inform the users how to use the "*" search...

Example:

Like[What is the name you are searching for?]

when they enter in the wild card (just like DOS) they can search for those types of issues

Good Luck