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 test type's own heading. What makes it harder is that for each test type (MA, RA, WE) there may be a different number of records for each student.
Is there a way to do this, so that I can have a then have my report display all the records by student of all their tests.
Please assist. Thank you I am using Access 2003
Best Wishes.
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 test type's own heading. What makes it harder is that for each test type (MA, RA, WE) there may be a different number of records for each student.
Is there a way to do this, so that I can have a then have my report display all the records by student of all their tests.
Please assist. Thank you I am using Access 2003
Best Wishes.