May 28, 200421 yr Question is for a database (v5.5) that is used for insurance calculations. There is one field that is "X" which I enter manually, that ranges from 100-300 in intervals of 10. Another field is the "Y" which I enter manually that is multiplied with the above "X" for a total. (X * Y = total) 210 * 15 = 3150 Now it only gives a result for one calculation as above, what I would like is to be able to put in the "Y" and have it calculate and display all the totals ranging in the 10 increments from 100-300 instead of just one. Thank you in advance.
May 28, 200421 yr Don't tell anyone I suggested this. Set up two repeating fields. One, Consts, holds the 20 numbers 100-300. The second is a calculation = Y * Consts. You should make Consts Global.
May 28, 200421 yr Author muchas gracias Paul. X (Consts) number repeating Y number Z = Extend(Y) * X works just fine!!
Create an account or sign in to comment