Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Sorting data in a report

    Ok - I have been dealing with this problem for a while. I need someone to help me.

    I have grade information for students in a table. Each Term and class has it's own record.

    ex. ID Term Teacher Room Grade
    11525 1 Smith 121 B
    11525 2 Jones 120 A
    11525 3 Siler 111 B

    I need a report to print out for each teacher that will tell that teacher where to send his kids the next term.

    So the report has to be sorted by term (1,2,3,etc) teacher but then show the next term information.

    EX. Term 2 Jones
    Jon Beck Smith Term 3
    Jance N Owens Term 3

    I also need a report to print out for each teacher their current list of kids and all their past data. I can print current rosters for teachers with no problem, but the problem comes when I want to see a students data for every Term, not just the current one.

    If anyone wants to tackle this one I'd sure appreciate it. i'm really stuck.

  2. #2
    Join Date
    Jul 2008
    Alexandria, Egypt.
    Dear Rjsiler,

    Do you still have the problem and need help ??

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

Similar Threads

  1. Sorting By Date!
    By Pirate in forum Access
    Replies: 0
    Last Post: 07-19-2007, 02:42 PM
  2. Report SQL/Data in Access
    By artfuldodger in forum Access
    Replies: 2
    Last Post: 09-01-2006, 07:38 AM
  3. Sorting in a subform
    By hraup in forum Forms
    Replies: 2
    Last Post: 08-29-2006, 12:35 PM
  4. How to report data in fical year order
    By gemini2 in forum Reports
    Replies: 1
    Last Post: 05-27-2006, 06:26 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 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