<br><br><b>Please tell me in specific terms how I should update a field in a record using a query, from the sum of two other fields in the same record.</b><br><br>This has plagued me for some time. And since the question has been raised (another members question). Well, I really need the answer to this one.<br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
update field in record using two fields from same record 1
- Thread starter Amiel
- Start date
-
1
- #2
jimmythegeek
Programmer
If I understand your question right, then let's pretend for a moment.<br><br>You have a table named Table1<br>In this table you have 3 fields: AmtCharged, AmtPaid, Balance<br><br>Create a new query<br>Add Table1 to the query<br>Change the query to an update query (Query ¦ Update Query)<br>Drag the Balance field to the QBE Grid<br>In the "Update To" Row enter: [AmtCharged] - [AmtPaid]<br>Run the query<br><br>That's it if I understand your question.<br>This example uses subtraction, but you can use any calculations you want.<br><br>Hope this helps. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question