Designing a query to power report

[psycoperl]

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.

 

[marianne]

your problem is easy. just attach your existing db file here so I can see it. save it as ms access 2000 version.

 

[psycoperl]

Thank you, here is a cleansed data file with sample data.

 

[marianne]

check this out. you can design your own report.

 

[psycoperl]

Thank you for your assistance.

How does it record which test type it is when I fill out the form?

Thanks

 

[psycoperl]

Ok, I saw how you used a query to "Map" to common fields on the Test Table even though the forms look unique to the test type.

When I applied this to my live database, I could not get it to write the test type to the table. How can this be done?