A
Andrew C
Hi
I am wondering if you can put the folllowing code into the control source of
a field.
=if([average score]-[tournament avg]<0,0,[average score]-[tournament avg])
What i am wanting i if the Persons average is lower than the tournament
average they get 0 points. If their average is higher than the get the
difference between the two figures.
If this is not possible with the code i have can someone please explain to
me what has to be done.
Thanks for your help
Andrew C
I am wondering if you can put the folllowing code into the control source of
a field.
=if([average score]-[tournament avg]<0,0,[average score]-[tournament avg])
What i am wanting i if the Persons average is lower than the tournament
average they get 0 points. If their average is higher than the get the
difference between the two figures.
If this is not possible with the code i have can someone please explain to
me what has to be done.
Thanks for your help
Andrew C