Retrieve Twice Each Record Sum

[codrutza]

CRXI
Maybe you could help me with this silly question.
I have a group on job.
The records I retrieve from the database come twice, it must be field or a link which I could use to retrieve them once, but I can’t find it now and it’s urgent.
Job Entry Entry No Value
232 ab 1 70.00
ab 1 70.00
314 y 1 10.00
y 1 10.00
433 a 1 80.00
a 1 80.00
d 2 60.00
d 2 60.00
522 r 1 30.00
r 1 30.00
e 2 50.00
e 2 50.00
q 3 20.00
q 3 20.00
ef 4 40.00
ef 4 40.00
600 ad 1 90.00
ad 1 90.00

Is it a way I can sum correctly the value?
Job Entry Entry No Value Sum per Job
232 ab 1 70 70
314 y 1 10 10
433 a 1 80
d 2 60 140
522 r 1 30
e 2 50
q 3 20
ef 4 40 140
600 ad 1 90 90
Total 450

 

[codrutza]

Sorry, instead of entry no, is item no

 

[Charliy]

To get your final total, set up a Running Total to Sum {value} evaluating on Change of Field {job}