Can access sum two fields in a form...

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/Forums.aspx/databases-ms-ac cess/200801/1

Re: Can access sum two fields in a form...

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