Search results

still can't get this done. What should i put in the query to sum up the Overtime hours? this is my current SQL Query: SELECT Qry_Report2_Overtime_Advanced_p1.Ref_Nr, Qry_Report2_Overtime_Advanced_p2_date.Ref_Nr, Qry_Report2_Overtime_Advanced_p2_date.Date...

hello, in Detail section within my report i have: textbox: Activity_Duration Control Source (referring to a column in my query): Activity_Duration textbox: Breaktime Control Source (referring to a column in my query): Breaktime and textbox: Normal_Labor Control Source (referring to a...

sorry wrong thread :)

These are the details of the other calculated fields: textbox: Sum_Duration Control SourcE: =Sum([Activity_Duration]) textbox: Sum_Breaks Control Source: =Sum([Breaktime]) textbox: Sum_Normal_Labor Control Source: =Sum([Normal_Labor])

Hello, i have created a report which calculates the labor hours from employees. I have for example the following fields in my report: Sum_Duration Sum_Breaks Sum_Normal_Labor and Sum_Overtime all above mentioned fields are shown in the Excelsheet when exporting the report to excel, except...