N/APosted on - 04/06/2013
Hallo Guys! I am looking for a code that is capable of querying database generating a monthly attendance report in SQL. The code should be such that it adds the number of days that someone has attended. Comment on whether this code can be expanded to include fingerprint recognition to enable verification of persons. Cheers.
How do I code a monthly attendance report in SQL?
You can first add the columns or rows using SUM then you can either subtract that with 28 or 29 for the month of February, and 30 or 31 for the other months of the year. You may also select the records before adding by month if there is a 'months' column in your database. After selecting, you may add the records. You can research more about SUM query from different websites like w3schools or at StackOverflow.