Text box with functions in Reports

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have database as follows:

Field 1 numeric - this varies
Field 2 numeric - this varies
Field 3 numeric - this is a constant number and never changes
Field 1 and 2 are always multiplied by Field 3

I have three text boxes with functions in them

Text Box 1 point total after multiplying Field 1 by Field 3
Text Box 2 point total after multiplying Field 2 by field 3
Text Box 3 equals sum of Text boxes 1 and 2

For Example:

Field 1 = 10, Field 3 = 40 Text Box 1 = 400
Field 2 = 06, Field 3 = 40 Text Box 2 = 240

Text Box 3 = 640

I have a report that reflects data such as: Field 1, 2, and Text Box 3;
however I can not get the report to reflect information noted in Text Box 3
for all records. It just returns the same data for all records. Hence, I
have a hundred records with the same data - eg. 100 records reflect 640 when
Text Box 3 data for each record may vary.

What is the best way to return the correct information in the report when
data noted in Text Box 3 may variy for each record?

Any response to my post is deeply appreciated.
 
Do the calculation using the fields rather than the text boxes
=(field1 * field3) + (field2 * field3)
 
Hi Dave:

Thanks much for your assistance. Did as you suggested with perfect results.
Thanks once again for timely and professional help.
 
Back
Top