I'm trying to get data from three tables but am having trouble limiting data from the third.
Table 1 contains ID and Name
Table 2 contains ID , Test Dates, Test results
Table 3 contains ID, Attendance Dates, Length of Attendance
I'm trying to get the report to return only: ID, Name, Test Dates, Test results, Length of attendance (on dates of test)
The problem is there are far more attendance dates than test dates.
I'm having trouble figuring out how to get it to return only length of attendance for the Test dates.
Any help would be greatly appreciated. Thanks, Fredoh
IP Logged
