By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Can access sum two fields in a form...

P: n/a
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

Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jan 31 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.