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

Outcomes