Sum of Crosstab in Report

[titanl]

Hi everyone,

I have created a Report based on a Crosstab. I'm trying to add up the total of students from the different schools but got an Error.

I am using a text box in the Footer with the following code:

 Sum([TotalOfStudents])

Why the Error? NB. I have calculated in reports base on tables or select queries before with success but the problem seems to be the Crosstab.

Any suggestions?

Thanks for the help.

 

[titanl]

Hi,

Everything is ok now! I experimented in the Report and eventually I realise that I had put the textbox control source in the wrong section! I was using the Page Footer instead of the Report Footer.

titanl