Hi,
Assuming all your fields have a different name ( e.g. TextField1, TextField2.....)
You code could look something like this
this.value = TextField1.value + TextField2.value + TextField3.value + etc..........
and place this code in the calculate event of the field you want to total.
To get the average you just need to divide the answer using standard coding techniques
this.value = totalField.value / TotalNumberOfFields
and place this code in the calculate event of your average field.
If you fields have the same names then it becomes a little more complicated and although I have placed this on the calculate event, it could easily be run by a button on the exit even of a field.
( I have assumed all the fields are in the same subform for the code)
hope this helps
Regards
Malcolm