Hey Guys
I have two forms
one form that has the calendar control box as well as
three textboxes
txtstartdate
txtenddate
txtdaterange
I also have a combo box that displays agent's names
and a combo box with the status of the employee's attendance so if they were absent for two days the txtdaterange would be 2 and the status would be absent.
I am able to create a sum total of all absents or lates on the form but I also have a send form and this form has the agent's profile on that profile I would like to have it so that it gives me the sum of all the lates and sum of all the absents only. Let me know if this can be done
thanks.
I have two forms
one form that has the calendar control box as well as
three textboxes
txtstartdate
txtenddate
txtdaterange
I also have a combo box that displays agent's names
and a combo box with the status of the employee's attendance so if they were absent for two days the txtdaterange would be 2 and the status would be absent.
I am able to create a sum total of all absents or lates on the form but I also have a send form and this form has the agent's profile on that profile I would like to have it so that it gives me the sum of all the lates and sum of all the absents only. Let me know if this can be done
thanks.