• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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.
0
PawloA
Asked:
PawloA
1 Solution
 
Rey Obrero (Capricorn1)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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now