surtur Posted May 28, 2004 Posted May 28, 2004 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.
Oldfogey Posted May 28, 2004 Posted May 28, 2004 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.
surtur Posted May 28, 2004 Author Posted May 28, 2004 muchas gracias Paul. X (Consts) number repeating Y number Z = Extend(Y) * X works just fine!!
Recommended Posts
This topic is 7584 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now