Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: Access Database Queries not working

    Hi!

    I've been working on an Access 2007 database for a bit now, but I can't seem to get past this one problem. I'm pretty new to Access, so I might just be doing things wrong... but so far, I've tried making junction tables and different types of joins/relationships and subsheets and none of these things have solved the problem that I have.

    The database I'm working with contains three separate sheets: Classes, Instructors, and Students. These come with the primary keys Class Number, Instructor ID, and Student ID respectively. In the Students sheet, I have the class numbers, one for each class the student goes to. In the Instructors sheet, I have the classes they teach, again one for each class they instruct. I'll note that because students and teachers often have more than one class, they have more than one field in the database (Class Num 1, Class Num 2, etc.) The Classes sheet contains all of the information for the classes, and their Class Numbers.

    I want to be able to make queries based on the students' classes. For example, I want to be able to find all of the students in one class number, and their instructors. Each query I've made has been missing data. I'm out of ideas for how to fix it, so I'm hoping someone here can help me!

    Thanks!

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Your data aren't normalized. I suggest you read up on normalization in the Help file, and restructure the tables.

    Sam
    PS Access works wirh tables, not 'sheets.' Are you coming from a spreadsheet program?

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    Thanks!

    And yeah, I'm switching from an Excel spreadsheet, which is why I used that term. Sorry, still pretty new to Access like I said.

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    You're very welcome.

    I thought so. No problem, I'm a power user in both programs; I have a healthy respect for the capabilities of Excel.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •