Performing field calculations on a form in Access 2000...

  • Thread starter Thread starter Chari Clark
  • Start date Start date
C

Chari Clark

I'm having trouble multiplying a field on a form by a
0.1. I would like to multiply one field by a number to
receive the result in another. In Expression Builder, I
enter the following value:

(field1)=(field2 * 0.1)

This has not worked for me. I know this may be trivial,
but I'm kind of a trivial person. Little help?

Thanks
 
Hi Chari,

Are you wanting to display a calculated value (recommended) or store a
calculated value (normally not recommended since it leads to a denormalized
database).

To display a calculated value, select the textbox that will display the
value, in the property sheet find the ControlSource property (under the Data
tab). In the controlSource Property put the following:

=[MyTextbox]*.1

Change 'MyTextbox' to the name of the appropriate control which is the other
factor in the product you are calculating.
 
Thanks, I'll definately give it a try. But do expect to
hear another post from me if I manage to mess it up.

Thanks!
Chari Clark

-----Original Message-----
Hi Chari,

Are you wanting to display a calculated value (recommended) or store a
calculated value (normally not recommended since it leads to a denormalized
database).

To display a calculated value, select the textbox that will display the
value, in the property sheet find the ControlSource property (under the Data
tab). In the controlSource Property put the following:

=[MyTextbox]*.1

Change 'MyTextbox' to the name of the appropriate control which is the other
factor in the product you are calculating.


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


Chari said:
I'm having trouble multiplying a field on a form by a
0.1. I would like to multiply one field by a number to
receive the result in another. In Expression Builder, I
enter the following value:

(field1)=(field2 * 0.1)

This has not worked for me. I know this may be trivial,
but I'm kind of a trivial person. Little help?

Thanks
Click to expand...

.
Click to expand...
 
Back
Top