Calculate results of query in repeating table

[Carlos F.]

I got a very small application using Infopath to submit and query data
of an Access Database. The database is quite flat and not complicated
since it stores different students evaluations.
For example:
EvaluationID
StudentID
Score Section1
Score Section2
Score Section3 etc.

For all intented purposes is working fine, but I hit a snag with the
query I wanted to do. I wanted a query that would show me all the
evaluations of a particular evaluator or student, so I digged through
Infopath and managed the result I wanted with a repeating table.

Everything was perfect until I decided that I wanted to do some
calculations per evaluation for review purposes. The results of the
calculations don't have to be stored anywhere, which I figured would
help me out. Unfortunately it hasn't.
Everytime I tried to do this, the result of the calculation of the
first query repeats itself out across the entire result list. Of
course, if my query only turns back one result, it works perfectly.

As you can gather, I have zero knowledge of code, which is why I am
hoping someone out there can give me a no-code answer.

Thanks,
Carlos F.

PS: I have tried current() in all its permutations without much success.

 

[Carlos F.]

Found solution!

My main problem was using a field for the data. Using an Expression Box
seemed to make current() work much better and I didnt' have problems as
I had with the field data. What I found disconcerting was that I used
current()/@ScoreSection1 on both occassions and it only worked ok on
the Expression Box! When I used it on a text box it didn't seem to work
properly.

Anyways.. There's my solution.