D
daniel
how could I show the dates for each month (1 to 31) automatically ?
Continuous form but also in Reports to print:
Month
Teacher (Combo to choose, not in reports)
Student (for the chosen Teacher)
Day Attended (Date, from first to last)
Hour(12pm to 8pm)
each hour has a different student.
Reports are printed for each Teacher, like:
Month: April
Teacher: Johnson
Date: Hour: Student:
04/01 3.00pm john doe
04/01 4.00pm jim small
04/01 5.00pm X (no scheduled student for that time)
.....
.....
04/02 2.00pm bill tall
....
....
data comes from the Enrollment query (tblStudent+tblTeachers..., Day,
Hour,...), (no, I'm not using the same words, Day, etc...)
I could just show the Days(Mon, Tue,...) for each teacher and his students
which would be simple,
coming from the query, but it has to have the dates and months showing so
the teachers can see from the reports what they did this month, every day.
(to check their payroll sheet/report), and compare it with their records.
Actual paydays are bi-weekly, payday is 17th and 2nd, days are filtered from
Begin, ending dates from a calendar in the form for all pay sheets to print.
I am just wondering how I can show the dates for each day. if we would
record every day, with the dates and hours, we would have it, but we're not,
there is no time for that. we would need one employee doing this all day.
any suggestions ?
thank you.
Continuous form but also in Reports to print:
Month
Teacher (Combo to choose, not in reports)
Student (for the chosen Teacher)
Day Attended (Date, from first to last)
Hour(12pm to 8pm)
each hour has a different student.
Reports are printed for each Teacher, like:
Month: April
Teacher: Johnson
Date: Hour: Student:
04/01 3.00pm john doe
04/01 4.00pm jim small
04/01 5.00pm X (no scheduled student for that time)
.....
.....
04/02 2.00pm bill tall
....
....
data comes from the Enrollment query (tblStudent+tblTeachers..., Day,
Hour,...), (no, I'm not using the same words, Day, etc...)
I could just show the Days(Mon, Tue,...) for each teacher and his students
which would be simple,
coming from the query, but it has to have the dates and months showing so
the teachers can see from the reports what they did this month, every day.
(to check their payroll sheet/report), and compare it with their records.
Actual paydays are bi-weekly, payday is 17th and 2nd, days are filtered from
Begin, ending dates from a calendar in the form for all pay sheets to print.
I am just wondering how I can show the dates for each day. if we would
record every day, with the dates and hours, we would have it, but we're not,
there is no time for that. we would need one employee doing this all day.
any suggestions ?
thank you.