Results 1 to 2 of 2
  1. #1
    MichaelA is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    139

    Reporting on only one person from a table.


    I created a gradebook database with students, school year, courses, assignments, and grades. I have the forms and tables working the way I want. Now I can't figure out how to get a report to return the grades of just one student. Thanks in advance for your help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Typically the report is based on a query, and you either include a criteria in the query or use this method:

    http://www.baldyweb.com/wherecondition.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 06-08-2018, 05:19 PM
  2. Replies: 19
    Last Post: 01-24-2016, 07:48 PM
  3. Replies: 1
    Last Post: 02-16-2015, 04:54 AM
  4. Reporting on fields in form not in table
    By keiath in forum Reports
    Replies: 6
    Last Post: 01-24-2014, 02:27 PM
  5. Replies: 1
    Last Post: 01-28-2011, 06:58 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