Hello Everyone.
I am a novice user of Access and I am having some trouble adding up hours over 24 hours. What I am doing is running a report that will show how many representatives have called out for the day and how many hours that added up for the center. Therefore if I have 3 employees who work 10 hours each calling out instead of showing 30 hours it is showing me 6. So this is what I did.
The report is divided by Site and then I have the employees under the Site (I have 2 sites).
I then added a Site Footer and in the Site footed I created a text box field and included =SUM([name of the field to be added up]). It addes up and it displays on the report and if the time does not pass 23:59 it shows correctly but once 24 hours hit it then shows the total-24 hours (I.E 26 hours would show 2 hours).'
The Format for that field is h:nn
Can someone help please?
Thanks.
I am a novice user of Access and I am having some trouble adding up hours over 24 hours. What I am doing is running a report that will show how many representatives have called out for the day and how many hours that added up for the center. Therefore if I have 3 employees who work 10 hours each calling out instead of showing 30 hours it is showing me 6. So this is what I did.
The report is divided by Site and then I have the employees under the Site (I have 2 sites).
I then added a Site Footer and in the Site footed I created a text box field and included =SUM([name of the field to be added up]). It addes up and it displays on the report and if the time does not pass 23:59 it shows correctly but once 24 hours hit it then shows the total-24 hours (I.E 26 hours would show 2 hours).'
The Format for that field is h:nn
Can someone help please?
Thanks.