calculation problem

  • Thread starter Thread starter taco
  • Start date Start date
T

taco

Hi Everyone;

Thanks in advance for your time and help. I'm trying to multiply variable
numbers with 0.01 or 0.02. I've wrote following expression into the control
box where I'll have the result.
=([CrIn]+[CrOut])*[TrValue]
When I'm multiplying 6,000 with 0.02 result is 12,000 instead of 120
Any idea why and how can I correct this ?
P.S. For all controls in this calculation Field Size is "Double", Format is
"Standard" and Decimal Places "2"
 
Hi Everyone;

Thanks in advance for your time and help. I'm trying to multiply variable
numbers with 0.01 or 0.02. I've wrote following expression into the control
box where I'll have the result.
=([CrIn]+[CrOut])*[TrValue]
When I'm multiplying 6,000 with 0.02 result is 12,000 instead of 120
Any idea why and how can I correct this ?
P.S. For all controls in this calculation Field Size is "Double", Format is
"Standard" and Decimal Places "2"
Click to expand...

Do you have any of these fields defined with a Percent format?
 
Nope... none of them defined like that... all of them Double and Standard

John W. Vinson said:
Hi Everyone;

Thanks in advance for your time and help. I'm trying to multiply variable
numbers with 0.01 or 0.02. I've wrote following expression into the control
box where I'll have the result.
=([CrIn]+[CrOut])*[TrValue]
When I'm multiplying 6,000 with 0.02 result is 12,000 instead of 120
Any idea why and how can I correct this ?
P.S. For all controls in this calculation Field Size is "Double", Format is
"Standard" and Decimal Places "2"
Click to expand...

Do you have any of these fields defined with a Percent format?
Click to expand...
 
Nope... none of them defined like that... all of them Double and Standard

John W. Vinson said:
Hi Everyone;

Thanks in advance for your time and help. I'm trying to multiply variable
numbers with 0.01 or 0.02. I've wrote following expression into the control
box where I'll have the result.
=([CrIn]+[CrOut])*[TrValue]
When I'm multiplying 6,000 with 0.02 result is 12,000 instead of 120
Any idea why and how can I correct this ?
P.S. For all controls in this calculation Field Size is "Double", Format is
"Standard" and Decimal Places "2"
Click to expand...

Do you have any of these fields defined with a Percent format?
Click to expand...
Click to expand...

Doublecheck the Format property of the *textbox* on the form. The fact that
it's multiplying by 100 really makes me think that a Percent format has snuck
in somewhere!

You may want to try deleteing the control from the form; compact the database;
and re-add the textbox. There might be some subtle corruption in the form.
 
Thanks a lot for advice and your time. I'll try to delete and re-add the
textbox.

John W. Vinson said:
Nope... none of them defined like that... all of them Double and Standard

John W. Vinson said:
Hi Everyone;

Thanks in advance for your time and help. I'm trying to multiply variable
numbers with 0.01 or 0.02. I've wrote following expression into the control
box where I'll have the result.
=([CrIn]+[CrOut])*[TrValue]
When I'm multiplying 6,000 with 0.02 result is 12,000 instead of 120
Any idea why and how can I correct this ?
P.S. For all controls in this calculation Field Size is "Double", Format is
"Standard" and Decimal Places "2"

Do you have any of these fields defined with a Percent format?
Click to expand...
Click to expand...

Doublecheck the Format property of the *textbox* on the form. The fact that
it's multiplying by 100 really makes me think that a Percent format has snuck
in somewhere!

You may want to try deleteing the control from the form; compact the database;
and re-add the textbox. There might be some subtle corruption in the form.
Click to expand...
 
Back
Top