AnsweredAssumed Answered

Summarising a field with multiple records

Question asked by clark_mackenzie on Mar 4, 2018
Latest reply on Mar 6, 2018 by davidhead

I have created several tables with the same fields in each for payslips for staff members.  New records are created fortnightly with details entered. 


I want to create a new table to summarise some of the fields from the tables such as gross wages field from each record for each staff member. 


As part of this once a new record is created the desired fields contents are automatically transferred to this summary table and at the end of a period [every three months] a total is computed for each field/each staff. 


see images attached. 


Thank you