I am not able to attach the file. That link requires a login to retrieve the file, does it not? Patient IDTherapistDepartmentDate Shyam Hani153RyaanOccupational Therapy02/10/2024 Shyam Hani153RyaanOccupational Therapy04/09/2024 Shyam Hani153RyaanOccupational Therapy06/09/2024 Shyam Hani153SanjuSpe...
You can link to them, which will mean the database will always reflect updates of the data in the Excel files. You can then return the pro rata income per therapist per day with the following query:SELECT [Patient Attendance Tracker].[Date], [Patient Attendance Tracker].Therapist,...