J
June
On a report-how would I get the total number of hours
worked, per person for the designated time that is
selected by Calendar Begin and End date? If I selected 3
weeks on the calendar, I need to see:
Person 1 90 RegHrs, 10 Vac, Total 100
Person 2 85 RegHrs, 5 Vac, Total 90
I keep getting:
Person 1, 30 Reg, 10 Vac, 40 Total
Person 1, 35 Reg, 5 Vac, 40 Total
Person 1, 20 Reg, 0 Vac, 20 Total
Person 2, etc.
I've created a query that totals all these by EmpID but
when I select via the calendar, to view totals, I get all
totals since start of work. I put totals text box in
Report footer but that totals only the first employee and
the total appears on the last page. Help appreciated.
worked, per person for the designated time that is
selected by Calendar Begin and End date? If I selected 3
weeks on the calendar, I need to see:
Person 1 90 RegHrs, 10 Vac, Total 100
Person 2 85 RegHrs, 5 Vac, Total 90
I keep getting:
Person 1, 30 Reg, 10 Vac, 40 Total
Person 1, 35 Reg, 5 Vac, 40 Total
Person 1, 20 Reg, 0 Vac, 20 Total
Person 2, etc.
I've created a query that totals all these by EmpID but
when I select via the calendar, to view totals, I get all
totals since start of work. I put totals text box in
Report footer but that totals only the first employee and
the total appears on the last page. Help appreciated.