Multiple Groups

[Tonie]

I am using Access 2000. I have a Query called Classlist.
I need to do a report with 5 sorted columns. For ex:

Pd1 Teacher Pd2 Techer Pd3 Teacher Pd4 Teacher PD5 Teacher
StuName Stuname Stuname StuName StuName
StuName Stuname Stuname Stuname StuName
etc. These are all the Studnets in this teacher's classes


Next Pd1 Teacher Pd2 Techer Pd3 Teacher Pd4 Teacher PD5
Teacher
StuName Stuname Stuname StuName StuName
StuName Stuname Stuname Stuname StuName
etc. These are all the Studnets in this teacher's classes

ETC until all the teachers have been printed

 

[Duane Hookom]

Do you have a table structure that you would like to share? We don't have
any idea how your data is structured so we can't provide any information on
how to get it into the format you want.

 

[Tonie]

I did not know you could set up tables in a report. I just
have it grouped by Teacher PD 1, Teacher PD 2, Teacher PD
3. I had even wondered if I could do 5 columns. One for
each Period. So I am way over my head on this one.
Tonie

 

[Duane Hookom]

You are over my head if you can't provide some table/field information.

 

[TONIE]

Oh I am sorry. I thought you meant to make a table in the
report. The report is built off a query called Q-class
list that is pulling out the student's name and 5 classes
and 5 teacher's from a table called T-student/sched.

Do you need any other info?
Tonie

 

[Duane Hookom]

You still haven't provided your exact field names. Just type them in to an
email. I can't begin to understand how your data is stored.

 

[Tonie]

Ok here are the field names

Student ID
Last Name
First Name
PD 1 {Class Name}
T1 {Teachers Name}
PD 2
T2
PD 3
T3
PD 4
T4
PD 5
T5

We have teachers that teacher several subjects at once and
we want to
keep T1 and Pd 1. We have 5 periods a day. I tried to
sort by the 5
teachers and it does keep the teacher the same across. I
get Smith
PD1 Smith PD2 Jones PD3 . It seems to keep the studnet
in line.
For ex. If johnny has Smith PD1 Smith PD 2 Jones PD 3.

In the Report I want all of the same teachers to across
with their
students listed. For ex

Teacher Smith PD 1 Smith PD 2
Smith PD 3
etc....

Student 1 Class1 Student 1 Class1
Student 1
Class1
Student 2 Class1 Student 2 Class1
Student 2
Class1
This is a class list that each teacher gets so they know
who is in their
class on each subject.

I hope this helps. Remember we are a school a each
teacher wants a
list of all the student in their class during the day.

Thank you

Tonie

 

[Duane Hookom]

This is not a good table structure. Is there any way that you can change it?
You should have tables of students, teachers, classes, and combinations:
tblStudents
===========
StudentID
LastName
FirstName
etc

tblTeachers
=========
TeacherID
TchLastName
TchFirstName

tblClasses
=========
ClassID
ClassTitle
TeacherID (only if you never will have more than one teacher per class)

tblEnrollments
=========
EnrollmentID
ClassID
StudentID

This structure make class rosters and most other reports quite simple. If
you can't change the table structure than let us know.

 

[Tonie]

If I change the to the 4 different tables how do I group
and sort by teachers in a report?

 

[Duane Hookom]

You create a query of the tables joining the related fields. Then sort by
teachers.

 

[Duane Hookom]

I would create a report based on the tblTeachers. Add five text boxes across
the top and enter the values for the five periods.
="Period 1"
="Period 2"
....
="Period 5"
Then create a subreport based on a query of tblStudents and tblEnrollments.
You can add 5 of these same subreports and link each one to TeacherID and
one of the five period text boxes.

You might want to check out some of the crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

 

[Tonie]

Ok I did that. How do I do a subreport?

-----Original Message-----
I would create a report based on the tblTeachers. Add five text boxes across
the top and enter the values for the five periods.
="Period 1"
="Period 2"
....
="Period 5"
Then create a subreport based on a query of tblStudents and tblEnrollments.
You can add 5 of these same subreports and link each one to TeacherID and
one of the five period text boxes.

You might want to check out some of the crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP





.

 

[Duane Hookom]

A subreport is a report contained in another report as a control.

 

[Tonie]

Yeah so how do you set one up.

-----Original Message-----
A subreport is a report contained in another report as a control.

--
Duane Hookom
Microsoft Access MVP





.

 

[Duane Hookom]

You create a narrow report based on the tables students and enrollments. You
can then view main report in design view and drag the subreport from the
database window into the detail section of the main report.