setting up a form (calculations)

[donnan33]

I have a main form for the project number, work order, employee etc. I have a subform for the tasks, pay rate, hours, etc. On my subform i have put a text box to get total payrate*hours. Each project/work order can have multiple records in the subform. the employee will use this to enter their hours daily. They can work on multiple tasks to complete the work order for the project. Each task (row) has total at the end. I can't figure how to get the sum total of the calculated column for all the tasks/rows. i either get #name? or using operand without an operator? Can anyone help?

[SoftwareMatters]

If you want to get the total of a column just put a text box in the footer of the form and in it's control source put something like this:
=Sum([ControlName])

NB: Just swap ControlName for the name of the control you are trying to sum.