Summation of report 1

[cantech2]

I have 2 fields on a report, one is TESTSCORE (50) and the other is EXAMSCORE (80). When I create a text field on the report to add both fields ie =[TESTSCORE]+[EXAMSCORE], I get 5080 instead of 130. How do I resolve this ?

 

[WildHare]

Your fields appear to be text. Adding TEXT guys gets you the result you see.

Try

=VAL([testscore]) + val([examscore])

to convert the textual digits to their numeric values beforehand.,


Jim


If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[cantech2]

Jim,

thanks. I checked my table and they were text fields. I changed them to number fields and my report is. Ok.

God bless you,
Cantech2

 

[cantech2]

Next question:

Now, on the same report, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page break after each students details. The scores and grading work fine.

My question is, how do I make a field called POSITION to show that Jack was 1st, Jill was 3rd and Bill was 2nd so that I can easily print each students report. And if 2 students have the same score, they should have same position.