access modifying table fields

Hello.
Being fairly new to Access and having worked in DBASE and other database operations. I would like to know how to take two fields in one table, add them together and store the result in another field.

database table
----------------------
ex field 1 = price
value =4.44
field 2 = qty
value = 2
field 3 = result
value = (This is to be done by taking 4.44 x 2 = 8.88 and this value is stored in field3).
I know it is simple but I just have to figure out how to do this type of operation.
LVL 1
PawloAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
normally you don't store calculated values to the table, you can always retrieved the correct information using a query even if the value from one of the field changed.

create a query like this

select [price],[qty], [price] * [qty] as result from tableName
0
 
Simon BallCommented:
this would be an update query:

create a query based on the table
change it to be an update query
write the top line to be the sum
[field 1]*[field2]

and select field 3 in the update to row.
0
 
Simon BallCommented:
do you want it to occur for all rows or a specific row?

is this a data entry form?  if its a form, it can be done in code on the form and update a hidden field...
0
 
lorenjcsmithCommented:
If you are using Access 2010 this can be accomplished with a calculated field

Add a calculated field to a table
0
 
PawloAAuthor Commented:
I want to update certain rows based on criteria I enter in an input form which I have to find out to make.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.