I have 4 Tables (Students, Test_MA, Test_RA, Test_WE) with a common relationship on StudentID between all of them.
I need to create a query for a report that would by each student (ID, Name) Which would print out their record for each test type which are stored in the other 3 tables under each...