Calculating total

[khood]

I have a main form with student info (name address, city etc). Also, there is a subform that includes class, credits, course date etc. How do I calculates the students total number of credits. This total can either be shown in the main or subform of the student from

 

[chilluk]

I'd do it on the subform.

Use "=sum([FieldName])" as the control source.

Otherwise use a DSum if you want it on the main form.

 

[khood]

I get an error message #Name? what does that mean?