Insert or recordset?

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

 

[tina]

yes, you can use a query rather than a recordset. to
update an existing record in a table, use an Update query.
to add a new record to a table, use an Append (insert)
query. read up on either type of query (or both) in Help,
to understand how they work.

 

[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

 

[roger]

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

 

[TC]

I was right. You ARE an imbecile.


DO NOT MULTI-POST
=================

*CROSS* POST
============

TC