>All,
>
>I'm doing a project for marking student attendance. The Fields that I have currently are STUDENTID and DATE. Each student who attend on a certain date will be marked. I was wondering whether I could keep adding the new DATE field to the Table using command, like what we do in the database setup, modify structure?
>
>Or is there any better idea for marking attendance?
>
>
>Gan
There is an ALTER TABLE command. I am wondering why you are doing this. Are you adding more fields to the table (one for each date the student attends?). This would not be the answer, I would suggest adding a new record for each date - this way you don't need to change the table structure. What you would then do is select all records with a certain date and that then gives you a list of student IDs.