Query for 2 fields

[sondriven]

Is it possible to make a query's criteria pick data out for 2 seperate fields?

For Example:

Movie Database

Field One: Actor 1
Field Two: Actor 2
Field Three: Movie Name

I want to enter in a Name "Chris Farley" and have it sort Field one and two and list all the movies that contain Chris Farley.

Am i making any sense??

Thanks

 

[RichMorrison]

You are making sense, but .................
your table is not normalized and that causes you a problem.

Better to create a linked table of ActorToMovie. Each row in this table contains an actor and a foreign key that points to the Movie table. You join the table and use one parameter for actor name. You get all movies where Chris Farley was actor 1, actor 2, .. and so on.

RichM