Help to calculate Sub Total field of found records

[beckham]

Hi I am trying to find away to calculate the the total sum held in a field named "sub total" on all FOUND records, can anyone advise please?

eg. record1 shows a sub total of 21000 record4 shows a sub total of 5000 therefore it should show the calculation of 26000 in the target field.

records 2 & 3 are not in the found set and should be ignored.

Thanks in advance for any help offered.

[comment]

43 minutes ago, beckham said:

record1 shows a sub total of 21000 record4 shows a sub total of 5000 therefore it should show the calculation of 26000 in the target field.

I am not sure what you man by "sub total" here. In general, you would use a summary field to total the values in a field for all records of the found set.