Calculating one record/Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Tiffany said:
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.
Click to expand...

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.
 
Hey thanks, It worked. :)
Much appreciated.

Rick Brandt said:
Tiffany said:
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.
Click to expand...

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.
Click to expand...
 
Back
Top