H
Hilarys
I am setting up a teacher's Yearly lesson planning database.
I have a continuous form called PlanFrm with LessonDate, LessonDay(Mon,
Tues etc), Week (1 or2), Period (1-5),Class, Room, & PlanningNotes fields in
each row based on the PlanQuery. I want all but the Planningnotes to be
automatically updated.
I have 3 tables:
MainTable with LessonID, LessonDate, TimetableID, PlanningNotes.
Timetable with with Timetable ID, LessonDay, Week, Period,Class, Room.
TermDates, with TermID, StartDate, EndDate.
The 2 week (10 day) timetable, which has 5 periods to each day, has been
imported from Excel.
I would like to run a query/queries to update the main table with all the
weekday dates between the start and end dates of a term and also with the
timetable for each day so that the teacher can scroll through a whole term's
lessons at a time on the form. When it is updated with the next terms dates
and timetable, the timetable would have to follow on ie if term 1 ended on
the Friday of a week 1 the new term would have to start on Monday of week 2.
Can any one help,please. I'm really stuck.
I have a continuous form called PlanFrm with LessonDate, LessonDay(Mon,
Tues etc), Week (1 or2), Period (1-5),Class, Room, & PlanningNotes fields in
each row based on the PlanQuery. I want all but the Planningnotes to be
automatically updated.
I have 3 tables:
MainTable with LessonID, LessonDate, TimetableID, PlanningNotes.
Timetable with with Timetable ID, LessonDay, Week, Period,Class, Room.
TermDates, with TermID, StartDate, EndDate.
The 2 week (10 day) timetable, which has 5 periods to each day, has been
imported from Excel.
I would like to run a query/queries to update the main table with all the
weekday dates between the start and end dates of a term and also with the
timetable for each day so that the teacher can scroll through a whole term's
lessons at a time on the form. When it is updated with the next terms dates
and timetable, the timetable would have to follow on ie if term 1 ended on
the Friday of a week 1 the new term would have to start on Monday of week 2.
Can any one help,please. I'm really stuck.