Creating an Access query: Query By Example - Still need help

[Australia]

Thanks for the two replys. But my problem is still not solved.

Actually I need to create a query. And I do not want to ask any other question from the user other than 'director name'. So how can we provide a SQL query so I can replace it in the SQL view of my Access query.

--------------------------------
My original question was:

I have three tables called DVD, Movie and Director. I need to create a query to ask the user for the name of a director and retrieve the DVDs directed by that director.

Director - Movie (Director ID is the foreign key in the Movie table)
Movie - DVD (Movie ID is the foreign key in the DVD table)

Please help me in code...

 

[allanon]

If this is not what You are after then post your table structures and I will help you more:

SELECT DVD.DVDName
FROM (DVD INNER JOIN Movie ON DVD.MovieId = Movie.MovieId) INNER JOIN Director ON Movie.DirectorId = Director.DirectorId
WHERE (((Director.DirectorName)=[Enter Director Name]));

 

[tlbroadbent]

Check thread181-281235 for an answer.

May I sugeest that you join Tek-Tips rather than posting as a visitor and avoid posting the same question in multiple forums.

Thanks, Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.