Search results

I have a db for movies that I own. I would like to make a query so that I could find movie title if I can remember several of actors in the movie. for example " what is the name of the movie with Paul Newman and Robert Redford" Any suggestions ?

I have a db for movies with some many to many relationships ie movie has several actors or several genres. How can I run a query that does not return all results for the criteria field, but still searches through them. For example I would like to be able to run query for all movies from 1972...

Trying to run query with criteria based on combo box in search form with no luck. If I use text box in search form I can make it work. About to pull out what little hair is left. Any ideas or suggestions ?

I have a multi value combo box in a form that populates another table. Is there a way to make it so when you begin to type in the box a record is suggested, ie. type the letter "c" and records beginning with the letter "c" are brought up and then and then a selection can be made. As it is now I...

Table is Movies Fields are Title,actor1, actor2 etc would like to be able to query all actor fields to see what movies they are in. In other words I would like to see all movies a certain actor appears in. New to this please forgive my ignorance......any suggestions