hi:
i have a table for Student attendance. the table have "id" "month" "lastname" "firstname" Then i have the day fields "a"b"c"d"e" etc'
what i need is to SUM all "yes" days fields for a month and show it as percentage for Each student. so in the student form I will put a text box named "present" for example the result "present 80%" for the last month
Sorry for syntax errors
i have a table for Student attendance. the table have "id" "month" "lastname" "firstname" Then i have the day fields "a"b"c"d"e" etc'
what i need is to SUM all "yes" days fields for a month and show it as percentage for Each student. so in the student form I will put a text box named "present" for example the result "present 80%" for the last month
Sorry for syntax errors