janet0211

Thanks for your time. I am so stupid that i misunderstand your answer, but solve it now. Please forgive me as a new user of Filemaker & really Thanks a lot.

Help expert further Qs, I want to make a report like this: tblAttendance.Branch.Main tblAttendance.StaffID tblAttendance.Branch x Hour x $ tblAttendance.Branch x Hour x $ tblAttendance.Branch x Hour x $ tblAttendance.Branch x Hour x $ Total $ I want to print all staff payroll slip under Main branch group, how to setting in the layout/report? Thanks Thanks Expert

Let me try it. I think problem solve. Thanks so much.

That's great. And how to do i want to add date range in the report. (Attendance table have date field) Thanks Thanks again

Thanks for your kind attention. - attendance table have staff_code, branch_code, and working hour - just want to group attendance.staff_ID then group attendance.branch_code - base on attendance.staff_ID and attendance.branch_code to calculate each staff working hour in report attendance table date staff_id branch_code working_hour 1/1/2016 A111 COD 1 2/1/2016 A111 ABA 2 3/1/2016 A111 COD 1 4/1/2016 A111 ABA 3 5/1/2016 A111 COD 1 6/1/2016 A111 COD 2 7/1/2016 A111 EXE 1 8/1/2016 A111 COD 2 9/1/2016 A111 COD 1 10/1/2016 A111 ABA 3 . A111 COD 3 . A111 ABA 2 . A111 ABA 1 . A111 ABA 2 31/1/2016 A111 EXE 3 1/1/2016 A222 ABA 1 2/1/2016 A222 ABA 2 3/1/2016 A222 EXE 2 4/1/2016 A222 ABA 3 5/1/2016 A222 EXE 4 . . . . Report A111 Branch COD <sum COD working_hour> x hour salary $ = COD salary$ ABA <sum ABA working_hour> x hour salary $ = ABA salary$ EXE <sum EXE working_hour> x hour salary $ = EXE salary$ Total Salary = COD$ + ABA$ + EXE$ Thanks a lot

I want to make a report like as attachment. how to group the branch code and calculate the hour & $. Thanks for your help.