recordsets related

[roger]

Hello Friends:

I have a table which keeps a track of all the training
sessions for computer based training that a student has
had and then I have an another table in which the
adminstrator for this training program would have the
ability to store exemptions for these students.

So for eg. if a the student is schedlued to take a class
on say Tuesday at 10-12 AM and if that Tuesday is a
holiday the admin would give an exemption for that
student. What I want to do is write recordset code where
it will look at what the exemptions are and accordingly
grant the exemptios to these students. That way the admin
can give exemptions for say 1 day and it will
automatically grant exemptions to all the students who
were scheduled for that day.

Is there an other way to do these?

 

[Kelvin]

I assume you are keeping track of the attendance as well. Since there will
be a record for each day of attendance even if it is a holiday, I would
modify this attendance tracking so that it could accept, "Attended",
"Nonattended","Exempted", and so on. Then you could just use an update
query to modify this field for each student. When you need to use the data
just filter out these records.

Kelvin

 

[roger]

Thanks for your help.

Yes I do have a table with attendance and so what I can do
is every week Friday I can run an update query on these
records and that way I can update these records.

Will the update query though let the user choose like
which student numbers to select at run time or to selct
ALL at run time? How would I do that.

 

[Kelvin]

It depends on how you write the update query. If you don't put in any type
of criteria then yes it will apply to all students. If you want to pick a
specific class, then just modify your query to only select students in the
class you want. You can have the query ask a parameter that you enter
before the update is performed, or you can add fields to the form calling
the query and have the query set criterias based on whats on that form.
Just design your query the way you want. You could even create different
queries to update different things and just use different buttons to perform
the specific update.

Button1: Update all students
Button2: Update students taking Math classes only
Button3: Update students in Math 101 only

Good luck.

Kelvin