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.