recordset or what?

[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.

 

[TC]

You have recently been asked - politely - NOT TO FRIGGIN' MULTI-POST.

Now you are multi-posting under SLIGHTLY DIFFERENT SUBJECT LINES.

This is an excellent way to MINIMIZE YOUR CHANCE OF GETTING HELP.

Unless you are TRULY AN IMBECILE, go back and READ WHAT HAS BEEN SAID TO YOU
ABOUT THE DIFFERENCE BETWEEN MULTI-POSTING AND CROSS-POSTING.


* D O N O T M U L T I - P O S T *
===========================


* C R O S S * - P O S T
=================


TC

 

[Tim Ferguson]

You have recently been asked - politely - NOT TO FRIGGIN' MULTI-POST.

TC: save your blood pressure and just kill-file him...


Tim F

 

[roger]

YOU SHOULD NOT USE SUCH LANGUAGE HERE> THIS IS FOR
PROFESSIONALS AND NOT FOR SICKOS LIKE YOU>

 

[TC]

TC: save your blood pressure and just kill-file him...

Tim, I have done so. And you are spot-on with the blood pressure comment! I
came very close to blowing a fuse - a fairly rare event for me!

The silly thing is, that my only intention was to help the guy get better
help. But he is INDEED an imbecile, so the effort was a waste of time.

Cheers
TC