Calculating one record/Form

[Guest]

As mentioned, I've figured out how to calculate fields. Could some one please
explain to me if this is possible:

Record 1: Calculating the total for4 fields under "Total" for record 1
Record 2: Calculating the same as above, however I would only like the
fields to caculate record 2 ONLY.

At the moment it's calculating all the figures that I put in all 4 fields in
all records. I only want that particular record to calculate what's on that
page, not all the records.
The formula I am typing in the field is as follows:

=Sum([Regular Amount From Bank]+[CH Repayment for Loan]+[T Extra
Contribution]+[c Extra Contribution])

This formula is calculating all records.
Pls help.
Tiff.

 

[Rick Brandt]

As mentioned, I've figured out how to calculate fields. Could some
one please explain to me if this is possible:

Record 1: Calculating the total for4 fields under "Total" for record 1
Record 2: Calculating the same as above, however I would only like the
fields to caculate record 2 ONLY.

At the moment it's calculating all the figures that I put in all 4
fields in all records. I only want that particular record to
calculate what's on that page, not all the records.
The formula I am typing in the field is as follows:

=Sum([Regular Amount From Bank]+[CH Repayment for Loan]+[T Extra
Contribution]+[c Extra Contribution])

This formula is calculating all records.
Pls help.
Tiff.

Get rid of Sum(). Sum() works against rows, not arguments.

If you were adding 2+3+4 you wouldn't enter Sum(2+3+4), just plain old 2+3+4.

 

[Guest]

Hey thanks, It worked.
Much appreciated.

As mentioned, I've figured out how to calculate fields. Could some
one please explain to me if this is possible:

Record 1: Calculating the total for4 fields under "Total" for record 1
Record 2: Calculating the same as above, however I would only like the
fields to caculate record 2 ONLY.

At the moment it's calculating all the figures that I put in all 4
fields in all records. I only want that particular record to
calculate what's on that page, not all the records.
The formula I am typing in the field is as follows:

=Sum([Regular Amount From Bank]+[CH Repayment for Loan]+[T Extra
Contribution]+[c Extra Contribution])

This formula is calculating all records.
Pls help.
Tiff.

Get rid of Sum(). Sum() works against rows, not arguments.

If you were adding 2+3+4 you wouldn't enter Sum(2+3+4), just plain old 2+3+4.