Thanks Allanon. But the code you provided asks several questions other than Director name when the query is executed. But I need only the Director name to be asked by the user.
The exact table structures are:
1) Director
Director ID, Name, Address, City, Postcode, Date Of Birth
2) Movie
Movie...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.