Results 1 to 5 of 5

Thread: Limit Results

  1. #1
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    62

    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 Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    24,407
    Include in criteria:

    Or Is Null
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    62
    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 Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    24,407
    The criteria I suggest should include records where that field is null.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    hithere is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    62
    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, 06:24 AM
  2. Limit Report to top 5
    By Nathan Plemons in forum Reports
    Replies: 1
    Last Post: 01-26-2012, 08:55 AM
  3. Limit Query Results
    By ocampod in forum Queries
    Replies: 5
    Last Post: 01-07-2011, 08:47 AM
  4. Limit Query results to 5 contacts per site
    By wobvintage3 in forum Queries
    Replies: 2
    Last Post: 12-01-2010, 10:23 AM
  5. Partial Limit
    By bglaugh in forum Programming
    Replies: 1
    Last Post: 09-15-2010, 05: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
  •  
Tech Forums: Microsoft Office Forums