Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Australia

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

    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...
  2. Australia

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

    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...
  3. Australia

    Creating an Access query: Query By Example

    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...
  4. Australia

    Calculating age from Date of birth in a Access Query Field

    Hi, Can somebody help me how to calculate age from "Date Of Birth" field in a Access query? Thanks!

Part and Inventory Search

Back
Top