Results 1 to 3 of 3
  1. #1
    gazzieh is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    26

    Query not showing all records

    Okay, I am now being driven MAD!

    I have a list of students, a list of books, copy numbers and loans.



    I have created the relationship (Students < Loans > Copies > Book) and now want to create a single query that lists all students who can borrow a book.

    The restriction is that no student can take more than 3 books out.

    I have existing data and have entered it; where I now have many students who have borrowed and returned books, some have books out and some have never borrowed a book. I want to create a query that simply lists those students who can still borrow a book (< 3 loans currently out).

    The query I have is



    http://www.flickr.com/photos/garynewport/5453394304/


    However, this fails to list all students appropriately. It fails to list any student who has borrowed a book and returned it but has not borrowed a book since (therefore they have an entry in Loan Date and Return Date for each entry in Loan).

    Where am I going wrong?

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,505
    Suggest you post your database so that someone may try to create correct query without having to re-create your work.

  3. #3
    gazzieh is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    26
    Quote Originally Posted by alansidman View Post
    Suggest you post your database so that someone may try to create correct query without having to re-create your work.
    Thank you but I have it solved. Just one of those moments where I cannot see the wood for the trees and simply needed some time away for my eureka moment.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-16-2011, 09:08 AM
  2. Query Showing Non-Assigned
    By Flash76 in forum Queries
    Replies: 13
    Last Post: 02-03-2011, 01:40 PM
  3. Sql query not showing all the values
    By usr123 in forum Access
    Replies: 0
    Last Post: 02-24-2010, 07:32 AM
  4. Query showing averages for groups
    By AnthonyTesta in forum Queries
    Replies: 1
    Last Post: 02-03-2010, 09:04 PM
  5. Replies: 7
    Last Post: 12-07-2009, 07:27 AM

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