Displaying a total textbox in a subform

[rmohebian]

Hello,
I have a form which displays student information and displays the deposited cheques in a subform for each student.
I am having problems displaying the total of one field inside my subform.


The query that I used for my subform consists of a cheque table.
The field inside my cheque table is as follows (cheque no, cheque date, notes and amount).
I want to total the amount of cheques for each student to show up in the bottom of my subform.
how can I do this?

[pbaldy]

In the form footer, try

=Sum(Amount)

[rmohebian]

I have tried that, but i get a #error result
any other suggestions

[pbaldy]

Make sure "Amount" is the name of the field in your data. You might also check that there are no textboxes that have the same name (which is exactly what the wizard will do). That will sometimes cause problems.