Results 1 to 4 of 4
  1. #1
    dedex13 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    1

    Dynamic Grouping

    I need a report that provides a listing of students by School District or by School District and then by School or by the Student's grade or by School then by the Student's grade (and probably other groupings I've not yet been asked to do) depending on what we are using the data for. Right now I have four separate reports but would rather have one report where I can select the grouping at run time. Is something like that possible (without having to go into the report and manually change the grouping)?

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    If the rest of the report is the same, then make up a name for the grouping (GroupField). Your query for the report can have that as an extra field, put whichever value you want in there - if it is District, let it carry the District, etc. On the form have a hidden field which you can use as the label/heading for the report, such as "District".

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    dedex13,

    You haven't mentioned tables, but I would suggest that tables and relationships are the most import part of database.

    Your post indicates you have (at least)
    Student
    StudentCourse (mark/grade)
    SchoolDistrict
    School

    For related info/tutorial see Martin Green's article on Dynamic Reports.

    Good luck with your project

  4. #4
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    when it comes to dynamic - for something like this you are better off using a Form object rather than a Report.

    With a continuous form - you can teach your users to right click in a field and select a Filter, and Sort - it's easy once they've tried it a couple times.

    If printing is needed - you could have a report that calls in the filter & sort properties of the form object - - but there is no easy way to dynamically manipulate grouping.

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

Similar Threads

  1. Grouping and Sum
    By dejhost in forum Reports
    Replies: 9
    Last Post: 08-20-2015, 07:01 AM
  2. Grouping
    By joeromero87 in forum Reports
    Replies: 2
    Last Post: 03-11-2015, 07:30 PM
  3. Grouping by certain qty.
    By reldridge in forum Queries
    Replies: 1
    Last Post: 12-03-2012, 03:41 PM
  4. Dynamic Form, Dynamic labels/ captions?
    By JFo in forum Programming
    Replies: 15
    Last Post: 10-12-2011, 08:33 PM
  5. Grouping By Age
    By xnixiel in forum Queries
    Replies: 1
    Last Post: 07-01-2010, 09:14 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