i'm trying to design an attendance register for pupils in a class for a term (3 months). I wanted to create columns for each day throughout the 3 months in the students table of the database but i feel this is too ambigous. The register will be marked either 'presence' or 'absence' everyday by the class teacher. Going by my own idea, there will be a gridview with 3 columns (ID, Name & Current date). The current date will have checkbox to mark presence or absence.
The end result is to get the total days a pupil was present in school for the term, i think there is a better way to do this. I'll be pleased if anyone can help me out, i'm using this as my final year project.....THANKS
View Complete Post