Results 1 to 2 of 2
  1. #1
    delorean004 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2014
    Posts
    1

    Can't figure out how to do this query


    Hello everyone. I have a movie database where there are tables movies, directors, and move stars. I am trying to create a query to display the fields of Movie Title and Movie Director. My issue is that I have one table that has only numbers which correspond to a certain director. The other table has the movie name as well as a number which corresponds to the director from the other table. So I want to make a query which will display only the title and name of director. My problem is that I can't figure out to make a query that will be able to take the director number from that tan;e and be able to link it to the actor/actress that has that number next to them. How would I be able to link the table with only the director number, to the other table which has the numbers and the names? i.e. access can figure out that the number refers to a director on a different table and is able to display the movie title and who directed it. I'm pretty sure I need to create a new relationship between the director number table and the actor table, and/or the director name and director number but whenever I try linking those I get a "type mismatch in expression". I'm sorry if this is all confusing, it's hard for me to explain and I'm also on pain killers from a recent surgery. Any help I cant get to point me the right direction will be greatly appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Why would there be a direct relationship between actor and director? The link should be through the movies they worked on together.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-12-2013, 01:21 PM
  2. Replies: 3
    Last Post: 05-09-2012, 05:27 PM
  3. Can't figure out Access query
    By luderbeck1 in forum Queries
    Replies: 3
    Last Post: 02-02-2012, 12:12 PM
  4. Need a query to figure all possible combinations
    By julestrip in forum Queries
    Replies: 1
    Last Post: 05-27-2011, 07:23 AM
  5. Cannot Figure this query out
    By ryan1313 in forum Queries
    Replies: 6
    Last Post: 08-13-2010, 12:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums