How to generate report with multiple records and horizontally recuring field.

[mtella1]

Hi guys.
I'm new in the forum. My problem is, I've a query with fields Student_ID(FK), Session_ID(FK), Term_ID(FK), Subject_ID(FK) and TotalMarks(Calculated) which I am using as the Record Source for my report. I want the report to display each record as Student_x, Subject_i-Score, Subject_j-Score, Subject_k-Score, ..., Subject_z-Score etc but each time I try I got stuck. I need help please. Thanks.

[Micron]

If your records are properly formed (e.g. in rows and not columns) you will need to base your report on a crosstab query. The nature of a ct query is that the number of columns is based on some sort of grouping and a group can have a different count from one time to the next, hence the number of columns can change and the report will fail. To combat this, your query needs a static group. See this for example.

If that doesn't help it's because "I got stuck" tells us - not much.