Can access sum two fields in a form...

[Fireguy via AccessMonster.com]

I have a DB form that gathers all my information for my database. It's quite
simple and straight forward. but I collect some redunant information in some
of the fields.

I was wondering if there was a way that access (in the FORM) can
automattically SUM two numbers from inputs into that same form.

for instance: Form has Input1, Input2, Input3, Input4, Input5.

Inputs1and 2 are text, 3,4 and 5 are numbers.

When I input numbers into 3 and 4, is there a way that "5" would
automattically SUM 3 and 4.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1

[fredg]

On Thu, 31 Jan 2008 16:41:46 GMT, Fireguy via AccessMonster.com wrote:

I have a DB form that gathers all my information for my database. It's quite
simple and straight forward. but I collect some redunant information in some
of the fields.

I was wondering if there was a way that access (in the FORM) can
automattically SUM two numbers from inputs into that same form.

for instance: Form has Input1, Input2, Input3, Input4, Input5.

Inputs1and 2 are text, 3,4 and 5 are numbers.

When I input numbers into 3 and 4, is there a way that "5" would
automattically SUM 3 and 4.

As control source of an unbound control on your form, write:
=[ControlA] + [ControlB]

The unbound control will be blank until both fields are filled in. Is
that what you want?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail