<div>
this would be an update query:<br />
<br />
create a query based on the table<br />
change it to be an update query<br />
write the top line to be the sum<br />
[field 1]*[field2]<br />
<br />
and select field 3 in the update to row.
</div>


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.

<div>
do you want it to occur for all rows or a specific row?<br />
<br />
is this a data entry form? &nbsp;if its a form, it can be done in code on the form and update a hidden field...
</div>


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...

<div>
If you are using Access 2010 this can be accomplished with a calculated field<br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/add-a-calculated-field-to-a-table-HA101820564.aspx" rel="ugc">Add a calculated field to a table</a>
</div>


If you are using Access 2010 this can be accomplished with a calculated field

Add a calculated field to a table [http://office.microsoft.com/en-us/access-help/add-a-calculated-field-to-a-table-HA101820564.aspx]

<div>
I want to update certain rows based on criteria I enter in an input form which I have to find out to make.
</div>


I want to update certain rows based on criteria I enter in an input form which I have to find out to make.

<div>
<div class="content wysiwyg-content">
Hello.<br />
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.<br />
<br />
database table<br />
----------------------<br />
ex field 1 = price<br />
value =4.44<br />
field 2 = qty<br />
value = 2<br />
field 3 = result<br />
value = (This is to be done by taking 4.44 x 2 = 8.88 and this value is stored in field3).<br />
I know it is simple but I just have to figure out how to do this type of operation.
</div>
</div>


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.

access modifying table fields

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.