"Attendance (in hours)" is a day to day data. One staff, one day, one record. If the design of "Attendance_Records" is fine, then for 1,000 staff, the table will have 365,000 records per year. Therefore I will need a method to calculate a weekly sum (adding 7 records) for each staff, should I...