How To "Sum" a value from different coloum

  • Thread starter Thread starter EricYau
  • Start date Start date
E

EricYau

im eric new user for using access.
im having a problem since i have using ms access and create a form...
and how to sum( +,-,/,*) a diffrent colum to get a total value .
 
I am assuming that you have the two fields displayed in textboxes on your
form now and want the sum of the two to be displayed in a third textbox.
Open the form in design view, click on one of the textboxes, press CNTRL-C
and then CNTRL-V. This creates a copy of the textbox. Click on menu VIEW -
Properties. Click on the textbox NOT copied. Highlight the information in
the Control Source and press CNTRL-C. Click on the textbox copy and using
CNTRL-V paste into the Control Source the information just copied WITHOUT
over writing what is already there.
Edit the Control Source information to look something like this --
=[First Source Info] + [Second Source Info]
This will display the sum of the two orignal fields.
 
Eric,
Please give us some sample fields... with sample values, and what you
want your expression to calculate.
ex.
Field1 Field2 Field3
10 5 20
The sum of those elements is...
= Field1 + Field2 +Field3
which would yield 35.
OR
The the product....
= Field1 * Field2 * Field3
which would yield 1000.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
im eric new user for using access.
im having a problem since i have using ms access and create a form...
and how to sum( +,-,/,*) a diffrent colum to get a total value .
Click to expand...

Since you don't describe anything about your table structure, the nature of
the form, what it is that you want to sum or how, I can't see how anyone could
give a rational answer.

Bear in mind: we're volunteers. We're not there and we cannot either see your
computer nor read your mind!

Could you perhaps describe your tables, and what calculations you would like
to do, perhaps with an example?

Do note that if you're starting your design with the Form you're on the wrong
track: your tables are fundamental, and the form is just a tool to manage data
in the tables.

John W. Vinson [MVP]
 
Back
Top