Data calculation?

Does anyone knows how to do data calculation in 'Access' " Forms." I want to
create 3 fields of data entries where the user input a numeric value in each
field and using the 4th fields for the calculation of the 3 data entriess.
My question is, how can I link the 3 fields of data together so that the 4th
field will output the right calculation?

Please Help! Thanks a bun.....

Your "fourth field" would be an unbound text field. In it's Control Source
enter the formula you want.


= [SomeFieldName1] + [SomeFieldName2] + [SomeFieldName3]


Rick B


"luke" wrote in message
...
Does anyone knows how to do data calculation in 'Access' " Forms." I want
to
create 3 fields of data entries where the user input a numeric value in each
field and using the 4th fields for the calculation of the 3 data entriess.
My question is, how can I link the 3 fields of data together so that the 4th
field will output the right calculation?

Please Help! Thanks a bun.....

Good morning

In the Control Source of the Text Box in which to wish to assign the value,
simply place the following formula:

=NZ(txtBox1,0) + NZ(txtBox2,0) + NZ(txtBox3,0)

Hope this helps

Maurice St-Cyr

Thank a lot Guys

It works

by the way what is NZ mean after txbox1,0

"StCyrM" wrote:

Good morning

In the Control Source of the Text Box in which to wish to assign the value,
simply place the following formula:

=NZ(txtBox1,0) + NZ(txtBox2,0) + NZ(txtBox3,0)

Hope this helps

Maurice St-Cyr

That tells access that if the value in one of your fields is nul, to replace
it with 0. Without that code, you might have received error messages
stating that you had an invalid use of nul. I'm glad Maurice suggested
that; it is the right way to do it.

Rick B


"Locke" wrote in message
...
Thank a lot Guys

It works

by the way what is NZ mean after txbox1,0

"StCyrM" wrote:

Good morning

In the Control Source of the Text Box in which to wish to assign the
value,
simply place the following formula:

=NZ(txtBox1,0) + NZ(txtBox2,0) + NZ(txtBox3,0)

Hope this helps

Maurice St-Cyr

Hi

The NZ function returns 0 when the evaluation is null.

You can lookup the NZ function in Help.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.