calculations

[Laurie]

I have two fields: text1 and text2. I have added these two fields with
=sum[text1]+[text2] in the control source.

Now what I want to do is to divide text 2 by the total from two fields to
get a percentage. For example: text1 (2) and text2 (10) for a total of 12.
Now divide text2 (10) by the total of 12. The result would be 83.33%.

What would the calculation be?

 

[Duane Hookom]

Your expression doesn't make sense. You should copy and paste your property
into a question so you don't introduce more errors. Sum requires ( ) like
=Sum([A]+).

Usually when we name something text1 or text2, this refers to text boxes
(controls not fields).

Are you actually summing records in a group or report header or footer? If
so, your expression might be something like:
=Sum([text2])/Sum([text1]+[text2])

 

[KARL DEWEY]

You probably want --
[text2]/([text1]+[text2])
- no Sum.