Hi - I am trying to create a report for our student body that lists out student schedules by student, then groups based off of first period class. The purpose of this is the first day of school we want to hand out a paper copy of the student schedules, and we want the printouts organized by room so we can quickly distribute.
What I have currently is a very simple table:
StudentID, Student Last Name, Student First Name, Class, Teacher Last Name, Teacher First Name, Period, Room
I then created a concatenated field of Room and Period, so it would be something like 2-Room100, meaning period 2 room 100.
I can create the report very easily to print out each student schedule by grouping by student ID. But then I want the order the student schedule groupings to appear to be based off of the first period, or this concatenated field I created. This is where I am stuck. I can seem to only group based off of student ID or the concatenated field...
Any ideas on how I can get the groups of schedules to be ordered by 1st period? I have been working on this for a couple of hours and I can't figure it out...
What I have currently is a very simple table:
StudentID, Student Last Name, Student First Name, Class, Teacher Last Name, Teacher First Name, Period, Room
I then created a concatenated field of Room and Period, so it would be something like 2-Room100, meaning period 2 room 100.
I can create the report very easily to print out each student schedule by grouping by student ID. But then I want the order the student schedule groupings to appear to be based off of the first period, or this concatenated field I created. This is where I am stuck. I can seem to only group based off of student ID or the concatenated field...
Any ideas on how I can get the groups of schedules to be ordered by 1st period? I have been working on this for a couple of hours and I can't figure it out...