Mark calculations

[Rose]

Hi, I am struggling to with a program i'm writing for a school. Learners get
to choose between two subjects at a time. I have created a combo box on the
form for them to choose, the problem now is the marks. What formula do i use
to calculate the classmark for the specific subject, because now the textbox
must calculate a mark for the subject chosen and not for both subjects in the
combobox...i would really appreciate any suggestions!! Thanx!

 

[Arvin Meyer [MVP]]

The formula will only calculate the active record in a single view form. If
there is a continuous form or datasheet, use a query as the recordsource and
add a calculated column to the query.