Summing Detail

[Blkblts]

I am using A97
I have several fields on the detail part of a report like:
QNum A1 CorrA1 QWeight txtDecision

Qnum is the question number
A1 is the users answer to question
CorrA1 is the correct answer
QWeight is the Weight of the Answer
sumofquestionweight
txtDecision is a calculated field =IIf([A1]=[CorrA1],"Correct","Wrong")

In my DateExam Footer I have Sum([sumofquestionweight])

The next thing I would like is to sum up the weights of all the "Correct" Answers and the weights of all the "Wrong" Answers

Any Suggestions?

Thanks
kim

 

[Blkblts]

Ok I got it figured out. I found out you can't just sum the field you have to sum the recalculation of the field....

Thanks
kim