Results 1 to 5 of 5
  1. #1
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    63

    Limit Results

    I have am creating a roster that I would like to have show students names, course taken, and letter grade.

    Each segment is it's own table: Students, Course and Grade.



    What I am trying to connect is all three tables and show the records where the grade is not an F or withdrew. The problem is - is when add the the grade critiera it removes those individuals that have an F or withdrew but also those patients that do not have a grade as well. Is there any to keep the blanks with those that have an acceptable grade?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Include in criteria:

    Or Is Null
    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.

  3. #3
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    63
    For some reason it is already pulling out the null values I actually want to include them.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    The criteria I suggest should include records where that field is null.
    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.

  5. #5
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    63
    Thank you!!!!

    I think my biggest difficulty was trying to recall specifically what AutoID corresponded to the letter grade since access requires me to specify the AutoID in the the query versus the actual letter grades to disculde.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  2. Limit Report to top 5
    By Nathan Plemons in forum Reports
    Replies: 1
    Last Post: 01-26-2012, 10:55 AM
  3. Limit Query Results
    By ocampod in forum Queries
    Replies: 5
    Last Post: 01-07-2011, 10:47 AM
  4. Limit Query results to 5 contacts per site
    By wobvintage3 in forum Queries
    Replies: 2
    Last Post: 12-01-2010, 12:23 PM
  5. Partial Limit
    By bglaugh in forum Programming
    Replies: 1
    Last Post: 09-15-2010, 06:49 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