totaling fields in a record

[Guest]

I have a form which has Contract Price to which I need to add or subtract
numbers in other fields. I set up the expression and it works fine except
that it totals all the records in the file. How do I restrict the
calculation to each record by itself?

Rich

 

[Jeff L]

You don't need to do anything fancy (no functions like Sum), just put
your calculation.
(FieldA + FieldB + FieldC - FieldD) * FieldE/FieldF....or whatever you
need to do.

Hope that helps!

 

[Guest]

I put that in (in control source) and it errors out. Am I entering it in the
wrong place?

Rich
--
Rich D
Armstrong Custom Homes
Redmond

You don't need to do anything fancy (no functions like Sum), just put
your calculation.
(FieldA + FieldB + FieldC - FieldD) * FieldE/FieldF....or whatever you
need to do.

Hope that helps!

 

[Jeff L]

Sorry, Rich, I just noticed that you were doing this on a form, and not
in a query. In the field on your form, you just put an = in front of
your calculation.
=FieldA + FieldB - FieldC.....

Substitute your field names in the calculation.

I put that in (in control source) and it errors out. Am I entering it in the
wrong place?

Rich

 

[Guest]

Sorry man, it must be my ignorance. I put the = sign in front and it says I
have a syntax error and won't even let it go. Exactly where should I enter
this expression?

 

[Jeff L]

In the textbox on your form, or you can double click the field to see
the Properties window, Click Data, and then put the expression in the
field labeled Control Source (with an = in front of it. If you are
still having trouble, you could try posting your expression and we can
go from there.