calculating a total in one field from other fields on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing some coursework for A Level ICT using Microsoft Access. I am
creating a database to manage the coursework and mock results of GCSE
students.

On my form i have some fields which will store marks(in numbers) there will
be an overall mark field also on the form. how do i calculate the total from
these marks, and have this put into the overall mark field, automatically?

please help.

Thank you

Emma
 
I am doing some coursework for A Level ICT using Microsoft Access. I am
creating a database to manage the coursework and mock results of GCSE
students.

On my form i have some fields which will store marks(in numbers) there will
be an overall mark field also on the form. how do i calculate the total from
these marks, and have this put into the overall mark field, automatically?

please help.

Thank you

Emma
Click to expand...

As control source of an unbound control on your form:
=Nz([ControlA]) + Nz([ControlB]) + (Nz([ControlC])

This calculated amount should not be stored in any table.
Whenever you need the sum, recalculate it, as above.
 
Back
Top