R
Ren
Hi i have a database in access 2002 for one of my classes for keeping thier
grades in I have it so that it adds the scores fore each student's work and
then base on that give a level of achievement
eg
task score (out of )
max score
student x 1 5
9
2 10
20
etc
it then gives a total grade and a level of achievement
eg ... 15/29
satisfactory
what i cant seem to get is the total for each performed in semester 1 and
semester 2
eg
task semester score (out
f ) max score
student x 1 1 5
9
2 1 10
20
3 2 5
10
4 2 6
25
total for semester 1 = 15 / 29 level = satisfactory
total for semester 1 = 11 / 35 level = low
I have tried
in the control source of ([score]) the following
=sum([score])where([semester])=1
but this doesnt work so i tried
IIf([semester])=1,sum([score])
but alas no luck
can anyone please help
grades in I have it so that it adds the scores fore each student's work and
then base on that give a level of achievement
eg
task score (out of )
max score
student x 1 5
9
2 10
20
etc
it then gives a total grade and a level of achievement
eg ... 15/29
satisfactory
what i cant seem to get is the total for each performed in semester 1 and
semester 2
eg
task semester score (out
f ) max score
student x 1 1 5
9
2 1 10
20
3 2 5
10
4 2 6
25
total for semester 1 = 15 / 29 level = satisfactory
total for semester 1 = 11 / 35 level = low
I have tried
in the control source of ([score]) the following
=sum([score])where([semester])=1
but this doesnt work so i tried
IIf([semester])=1,sum([score])
but alas no luck
can anyone please help