How to handle Urgent

Hai

here is the table
with
admission_No
Batch_code
roll_No
Date
status---present or absent

i want to enter the data to the table student
here i should enter admission_No,Batch_code,
RollNo only once for the entire period
say 30 days but i want to enter date and
status daily.how to do this.

I'm not sure I understand your question, but according to the question the matter is about a CHECKING routine; write a function that checks if the specified period is over or not and according to its return value you enter values for them or not. Hopefully this helps.

Wesam.

------------------

Hi,

Try two tables. One to identify your student and one to hold the status of their presence in class. Give each student a unique number. So your first table (Student) will be:

StudentNo
admission_No
Batch_code
roll_No

(Note: You do not have to assign a new number if you have one field to uniquely identify the student. The number will be used to make it easier to identify the student for the other table)

In your second table (Presence) you will have these fields:
StudentNo
Date
status---present or absent

This way, each day you only have to insert into presence, the studentno, date, status

(Note: any field that is suppose to change on a day to day basis will go in the Presence table, info that stays the same for one session goes in the student table.)

HTH,

Preeti