Solved Teachers database RELATIONSHIPS (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:36
Joined
May 7, 2009
Messages
16,453
the New Schedule report is in form 1_TeacherSchedule.

note the Paper size is A3 (wont fit on small paper).
 

Attachments

  • Teachers.accdb
    2.6 MB · Views: 36

ElizabethTaylor

New member
Local time
Tomorrow, 01:36
Joined
Mar 15, 2022
Messages
28
the New Schedule report is in form 1_TeacherSchedule.

note the Paper size is A3 (wont fit on small paper).
You are really very experienced in databases. Be blessed so much.
Your Report works perfectly.
I made a slight mistake in that excel spreadsheet.
I realized that you cannot filter to show classes and streams. Kindly take the following to be Report titles
1. Years
2. Term
3. Gradedesc
4. Stream
Then
Time
Teacher, Subject
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:36
Joined
May 7, 2009
Messages
16,453
do you wish also to Filter on those 4 attributes?
i can make a form that ask for those 4 attributes and
the report will be filtered but it's a little late here so i will leave off until tomorrow.
 

ElizabethTaylor

New member
Local time
Tomorrow, 01:36
Joined
Mar 15, 2022
Messages
28
do you wish also to Filter on those 4 attributes?
i can make a form that ask for those 4 attributes and
the report will be filtered but it's a little late here so i will leave off until tomorrow.
Kindly have a look at the attached excel spreadsheet.
I believe it is easy to be filtered if years, term, gradedesc, stream are at the title of the report. Kindly look at the adjusted time. Thanks so much
 

Attachments

  • TEACHERS SCHEDULE REPORT.zip
    7.4 KB · Views: 31

ElizabethTaylor

New member
Local time
Tomorrow, 01:36
Joined
Mar 15, 2022
Messages
28
@arnelgp kindly assist me to make a form to filter:
1. Years
2. Term
3. Gradedesc
4. Stream
I really really really appreciate from the bottom of my heart.
Thanks. Be blessed.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:36
Joined
May 7, 2009
Messages
16,453
open form 1_TeacherSchedule and press the Print Preview button.
 

Attachments

  • Teachers.accdb
    3.3 MB · Views: 55

Users who are viewing this thread

Top Bottom