How to work with this type of report

[Jamaluddin]

There are 2 tables in my database, one is Student Table and the other is Result. The first column of Report, i.e., Std ID comes from the Student Table. However, The English, Mathematics, Physics and Chemistry Marks are stored in Result table. The Result Table has following fields:

1. Subject ID
2. Subject Name


3. Max Marks
4. Obtained Marks

If I select the Subject Name for my second column in Report, its work fine for only one subject name. Basically I need the report like in the picture. This is, I think a type of cross tab report from 2 table. Any help in this regard is highly appreciated.

Regards.

[June7]

If you want to show the student names along with the ID, build query that is a join of the two tables. Build crosstab with the first query. Include the student ID and student name as row heading fields in the crosstab.

[Jamaluddin]

If you want to show the student names along with the ID, build query that is a join of the two tables. Build crosstab with the first query. Include the student ID and student name as row heading fields in the crosstab.

Hi June7. can you provide an example query please?

[June7]

I don't have data to build with. You should make attempt according to what I describe and post efforts for analysis if you have problems. You don't show but I assume Result table also has student ID.

Step 1. Build query that joins the two tables.

Step 2. Use query from step 1 as source for a crosstab.