@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.
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
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...
@arnelgp thanks so much for your help. I am trying to recreate the Report from teachers schedule to be like the one in this attached excel spreadsheet. It has taken the whole night and the whole day and I am defeated. Kindly assist me. Kindly look at this excel spreadsheet
@arnelgp I want to use 1_TeacherSchedule. Is it possible that the moment you select the teacher whose records have not been entered the teacherssubjectroom subform becomes blank because the records for the teacher have not been entered???? Records to be shown when a teacher whose records have...
@arnelgp how do you capture the error. If by mistake, the user writes the year manually in 2_TeacherAllSchedule it produces the error:
Run-time error '3464'
Data type mismatch in criteria expression.