calculations

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?
 
D

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top