calculating sums from one field or another field

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

Guest

I have created a database for managing the mock exam results and coursework
of GCSE languages students.

I have create a courseworkMark field, and ExaminationMarkF field,
ExaminationMarkH and an Overall Mark field.

I need the OverallMark field to show the total of the :

ExaminationMarkF plus CourseworkMark
ExaminationMarkH plus CourseworkMark

The user will be able to chose whether the ExaminationMarkF or the
ExaminationMarkH is added to the CourseworkMark in the OverallMark box.

How can I do this?? I thought about using check boxes or option boxes, but I
haven't been successful as yet.

Please Help.

Thank you in advance!

Emma
 
If you store just the result, then how do you know a) how it was calculated
and b) how do you update it should F or H change?

You probably need to record the fact the overal mark was calculated as
ExaminationMarkF plus CourseworkMark
as opposed to ExaminationMarkH plus CourseworkMark, rather than the actual
value.

If there are just 2 options, just add a boolean field called something like
MarkFplusCourse. If true, the total dislayed on the form is ExaminationMarkF
+ CourseworkMark

To do this, just add the option group in with the 2 different options bound
to the MarkFplusCourse field (or radio button or whatever you choose), and
on the after_update do

if me.MarkFplusCourse then
Me.OverallMarkTextBox = Me.ExaminationMarkF + Me.CourseworkMark
else
Me.OverallMarkTextBox = Me.ExaminationMarkH + Me.CourseworkMark
End if
 
Hi! It wouldn't work, it says something like the macro isn't available or
something. Is there any way to have a check box or option box next to each of
the ExaminationMarkF or ExaminationMarkH fields, and then only one box can be
selected, and that which is chosen, added to the coursework mark box and put
into OverallGrade field? The OverallGrade would then update automactically
when the marks are changed. I don't really know that much about M. Access, as
i'm only using it for A level ICT couersework, so I'm not sure whether what I
want to do will work, or how to do it.
Thanks for trying!
 
Back
Top