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

[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

 

[Sandra Daigle]

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.

 

[Chari Clark]

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.

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

.