calculations

  • Thread starter Thread starter Laurie
  • Start date Start date
L

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?
 
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])
 
Back
Top