Multiple field query

Hi,

Please could you help re the following.....

I have a movie database that contains fields of ACTORS 1 to 5.

I would like to create a single query that will allow me to search for the names of any one of the five actors as at the moment i have 5 seperate queries which is no good as you don't know which actor is in which field.

Also, is it possible to make a query that will allow me to search for any string of characters within a title. eg. "minat" would produce "Terminator"?

Thank you
Jon

SELECT * FROM MOVIES WHERE (ACTOR1 LIKE "*" & [SearchString] & "*") OR (ACTOR2 LIKE "*" & [SearchString] & "*") ... etc.

Thanks


Merry Christmas
Jon

Hi again,

ive input the sql that you suggested which i think should work fine, but it states that the from cause is incorrect but ive changed it to the name of the table where actors1..5 is stored.

Ive uploaded the DB to: http://www.aubp78.dsl.pipex.com/Movie%20Database.mdb

Please could you take a look and either FTP it or send me a scrn shot of the query with the code in it.

Thank you very much
Jon