Division Problem

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

How can I calculate to an unbound field numeric amount and show them as an
average rounded off
What do i put in the form column??? Need the average rounded off

=[Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19]/10
 
=Round(([Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19])/10,n)
Where n is the number of decimal places you want to round to. I would try
putting this in the Default Value Property of the text box where it is
displayed. Depending on what else may be going on in your form, you may have
to play with it to find the correct property of event to put it in.
 
The correct value for the equation should be 2.7 however it shows 27.00

Klatuu said:
=Round(([Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19])/10,n)
Where n is the number of decimal places you want to round to. I would try
putting this in the Default Value Property of the text box where it is
displayed. Depending on what else may be going on in your form, you may
have
to play with it to find the correct property of event to put it in.


Dave Elliott said:
How can I calculate to an unbound field numeric amount and show them as
an
average rounded off
What do i put in the form column??? Need the average rounded off

=[Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19]/10
Click to expand...
Click to expand...
 
That is odd, unless there is a syntax problem I am missing. The intent, as I
undestand it is to add the values in the 10 fields, divide them by 10 and
round it to 1 significant digit. That is what the code looks like.

Send me the values in the fields, please

Dave Elliott said:
The correct value for the equation should be 2.7 however it shows 27.00

Klatuu said:
=Round(([Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19])/10,n)
Where n is the number of decimal places you want to round to. I would try
putting this in the Default Value Property of the text box where it is
displayed. Depending on what else may be going on in your form, you may
have
to play with it to find the correct property of event to put it in.


Dave Elliott said:
How can I calculate to an unbound field numeric amount and show them as
an
average rounded off
What do i put in the form column??? Need the average rounded off

=[Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19]/10
Click to expand...
Click to expand...
Click to expand...
 
Here is my code (NEW) with the field in Fixed format with a Decimal Place
of (2)
Text43 simply counts the number values >0 in the Sample fields
I think this adds correctly???

=Round([Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19]/[Text43])/10



Klatuu said:
That is odd, unless there is a syntax problem I am missing. The intent,
as I
undestand it is to add the values in the 10 fields, divide them by 10 and
round it to 1 significant digit. That is what the code looks like.

Send me the values in the fields, please

Dave Elliott said:
The correct value for the equation should be 2.7 however it shows 27.00

Klatuu said:
=Round(([Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19])/10,n)
Where n is the number of decimal places you want to round to. I would
try
putting this in the Default Value Property of the text box where it is
displayed. Depending on what else may be going on in your form, you
may
have
to play with it to find the correct property of event to put it in.


:

How can I calculate to an unbound field numeric amount and show them
as
an
average rounded off
What do i put in the form column??? Need the average rounded off

=[Additional Sample]+[Additional Sample #2]+[Additional Sample
#3]+[Additional Sample #4]+[Additional Sample #5]+[Additional Sample
#6]+[Additional Sample #7]+[Additional Sample #8]+[Additional Sample
#9]+[Additional Sample #19]/10
Click to expand...
Click to expand...
Click to expand...
 
Back
Top