R
roger
Hello Friends:
I have 2 tables in my application.
A students table which losts all the 25 students taking
this online training program and the other table for the
attendance records of these students.
These students have sessions scheduled for them when they
do training on the computer; sometime they can get
exemptions of time off by the Training coordinator for
whatever reason such as holiday etc. In that case these
hours are not considered as used by the students and they
can get more time latter on.
I have to design a way whereby the admin can give these
students ALL or individually an exempt time. When he does
that a record must get entered in the tblattandance which
will show something like...
Stu_Clock_Num=20090,Exempt=yes,Hours_Exempt=4 hrs
How would I do that?
Can I only do it using a recordset only or can I do it
using an Insert,Update etc type of query.
I have 2 tables in my application.
A students table which losts all the 25 students taking
this online training program and the other table for the
attendance records of these students.
These students have sessions scheduled for them when they
do training on the computer; sometime they can get
exemptions of time off by the Training coordinator for
whatever reason such as holiday etc. In that case these
hours are not considered as used by the students and they
can get more time latter on.
I have to design a way whereby the admin can give these
students ALL or individually an exempt time. When he does
that a record must get entered in the tblattandance which
will show something like...
Stu_Clock_Num=20090,Exempt=yes,Hours_Exempt=4 hrs
How would I do that?
Can I only do it using a recordset only or can I do it
using an Insert,Update etc type of query.